Re: ALTER TABLE ADD UNIQUE .....

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ALTER TABLE ADD UNIQUE .....
Date: 2003-11-11 14:20:50
Message-ID: 29866.1068560450@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> writes:
> Looks like ADD UNIQUE( some_fuc( some_feild) ) is not supported with add constraint.
> the only way is to add the constriant is using UNIQUE INDEX .
> Is it a bug or intended behaviour?

It's intended. The syntax and behavior of unique constraints is defined
by the standard, and it doesn't include anything about functional
indexes.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message bob parker 2003-11-11 14:51:54 Re: Visio Like Tool....
Previous Message Christopher Murtagh 2003-11-11 14:03:20 Re: PL/Perl returning multiple rows