From: | "enediel" <enediel(at)com(dot)ith(dot)tur(dot)cu> |
---|---|
To: | "postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: doubts about a constraint's definition |
Date: | 2003-03-21 17:39:13 |
Message-ID: | 008a01c2efd0$cb1285e0$2824a8c0@nsoft |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Peter for your attention, it's exactly what I needed
:>)
Greetings
Enediel
Linux user 300141
Happy who can penetrate the secret causes of the things
¡Use Linux!
----- Original Message -----
From: "Peter Gibbs" <peter(at)emkel(dot)co(dot)za>
To: "enediel" <enediel(at)com(dot)ith(dot)tur(dot)cu>; "postgresql"
<pgsql-general(at)postgresql(dot)org>
Sent: Friday, March 21, 2003 6:32 AM
Subject: Re: [GENERAL] doubts about a constraint's definition
> enediel wrote:
>
> > I need to create a column, where the information is conserved in the
same
> > way that it was written by the user, but the data of this column is
unique
> > if it's only taken to capital
> >
> > declaring a constraint
> > ... unique(column name) is not enough to me 'cause
> >
> > 'ab'
> > 'AB'
> > 'aB'
> > ....
> > will be accepted
> >
>
> Create a unique functional index e.g.
> create unique index index_name on table_name (upper(fieldname));
> --
> Peter Gibbs
> EmKel Systems
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-21 17:46:59 | Re: FIPS 127-2 |
Previous Message | enediel | 2003-03-21 17:28:11 | Re: doubts about a constraint's definition |