unique index on more than one field using functions

Domingo Alvarez Duarte <domingo@dad-it.com>

From: domingo@dad-it.com (Domingo Alvarez Duarte)
To: pgsql-sql@postgresql.org
Date: 2001-07-22T10:14:46Z
Lists: pgsql-sql
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 ?