unique index doesn't accept functions on fields
Domingo Alvarez Duarte <domingo@dad-it.com>
From: domingo@dad-it.com (Domingo Alvarez Duarte)
To: pgsql-hackers@postgresql.org
Date: 2001-07-22T10:16:55Z
Lists: pgsql-hackers
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)) ); Anyone have an idea ?