[EMAIL PROTECTED] 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 a
I am on version 7.3. I have been able
to build a case insensitive index to keep the refullname column unique
with the following:
CREATE UNIQUE INDEX resource_refullname
ON resource USING btree
(upper(refullname) text_ops);
However I have a table where I want
to allow a duplicate refullname
