>Tom Lane <[EMAIL PROTECTED]> wrote on 04/06/2006
11:33:57 AM:
> [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 indexe
[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
