On Wed, 10 Mar 2004, Joseph Shraibman wrote:
> This works:
>
> ALTER TABLE segment ADD CONSTRAINT name unique(textfield, reseller);
>
> This doesn't:
> ALTER TABLE segment ADD CONSTRAINT name unique(lower(textfield),
> reseller);
>
> I had to create a unique index.
I don't think this is a bug since it means that we properly accept a
column name list in the unique constraint as per at least SQL92.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
