"Kynn Jones" <[EMAIL PROTECTED]> writes:
> ALTER TABLE foo
> ADD CONSTRAINT foo_unique_xy
> UNIQUE ( UPPER( x ), UPPER( y ) );
> ...I get a syntax error
This is disallowed by the SQL standard: UNIQUE constraints can only be
on plain columns. (The practical reason for following their rule is
that there'd be no way to represent more-general constraints in the
information_schema.)
Use the CREATE UNIQUE INDEX syntax instead.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
