Tom Lane schrieb:
Andreas <maps...@gmx.net> writes:
So I had the missconception that UNIQUE (...) within CREATE TABLE (...)
was actually just an shorter way to define a unique index which it is not.
Well, it is that --- it just doesn't provide access to all the features
that CREATE INDEX does.
So as it is a shortcut for "create index" then why would the function
call of upper not be accepted when the sql parser maps the
uniqe-constraint into the "create index" command? The parser could just
take everything in the ( ) and use it as is.
Somehow there must be a notice in the meta data to mark the difference.
pgAdmin shows a unique as constraint but no index when created within
"create table".
The unique-index only shows up when created seperately.
regards
Andreas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql