Re: Howto have a unique restraint on UPPER (textfield)

Tom Lane schrieb:
> Andreas <maps(dot)on(at)gmx(dot)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