>
>Right, but does the pattern_ops one have to be unique?
Sorry, I don't uderstand
>And if it does, do you need the normal unique constraint as well?
Sometime yes. It's about using natural or generated unique values.
I looked to source code and I propouse syntax:
CREATE TABLE name .. colname type PRIMARY KEY | UNIQUE [USING INDEX [TABLESPACE ...] [OPERATOR
CLASS opclass]
CREATE CONSTRAINT name PRIMARY KEY | UNIQUE '(' colname opt_class, ....
I don't think so this need big patch.
What do you think?
Regards, nice a day
Pavel Stehule
_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com.
http://www.msn.cz/