[SQL] unique index on more than one field using functions

[Domingo Alvarez Duarte]

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 ?

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster