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 ?
