Re: Unique constraint or index, case insensitive, on multiple fields - Mailing list pgsql-general

MargaretGillon@chromalloy.com writes:
> CREATE UNIQUE INDEX resource_refullname
>  ON resource  USING btree  (redtid, (upper(refullname) text_ops));

You need something newer than PG 7.3 to do that.  7.3 can't handle
functional indexes with more than one column.  There are many other good
reasons to upgrade anyway.

BTW the correct syntax would be

CREATE UNIQUE INDEX resource_refullname
 ON resource  USING btree  (redtid, (upper(refullname)) text_ops);

If you're going to put an opclass name, it goes outside the parens.
(The only reason the parens are required at all is to separate the
expression from the opclass name ...)

            regards, tom lane