RE: Re: unique index doesn't accept functions on fields

> > 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