Joseph Shraibman <[EMAIL PROTECTED]> writes:
> 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 don't think this is a bug. The unique-constraint syntax is
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
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.
---(end of broadcast)---
TIP 7: don't
