> > I'm trying create a unique index using more than one field and
> > applying a function in one field to achieve case insensitive
> > uniqueness but postgresql doesn't accept.
> >
> > create table a(
> > id int primary key,
> > id2 int not null,
> > name varchar(50),
> > unique(id2, lower(name))
> > );
>
> Have you tried to just CREATE TABLE and later CREATE INDEX UNIQUE
> USING... ?
Postgres does not support functional indexing on multi-key indices.
Chris
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
