Rajesh Kumar Mallah <mallah@trade-india.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