From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Andrus <eetasoft(at)online(dot)ee> |
Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to create case insensitive unique constraint |
Date: | 2005-09-21 16:47:11 |
Message-ID: | 1127321230.3026.201.camel@coppola.muc.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I guess you can create a unique functional index with upper as the
function. Try to look up the docs for CREATE INDEX.
HTH,
Csaba.
On Wed, 2005-09-21 at 18:15, Andrus wrote:
> I want to disable dupplicate customer names in a database regardless to
> case.
>
> I tried
>
> CREATE TABLE customer ( id SERIAL, name CHARACTER(70));
>
> ALTER TABLE customer
> ADD constraint customer_name_unique UNIQUE (UPPER(name));
>
> but this is not allowed in Postgres
>
> Any idea ?
>
> Andrus.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | John D. Burger | 2005-09-21 17:38:27 | Re: How to create case insensitive unique constraint |
Previous Message | Andrus | 2005-09-21 16:15:09 | How to create case insensitive unique constraint |