>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 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
I thought it might be version related. I had planned to upgrade soon and this is another good motivator.
Thank you,
Margaret Gillon
