>Tom Lane <tgl@sss.pgh.pa.us> wrote on 04/06/2006 11:33:57 AM: > 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
I thought it might be version related. I had planned to upgrade soon and this is another good motivator. Thank you, Margaret Gillon