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

2001-07-23 Thread Christopher Kings-Lynne
> > 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, low

[HACKERS] Re: unique index doesn't accept functions on fields

2001-07-23 Thread Alessio Bragadini
Domingo Alvarez Duarte wrote: > 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), > un