Re: Howto have a unique restraint on UPPER (textfield) - Mailing list pgsql-sql

Andreas <maps.on@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.
        regards, tom lane