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@emkel.co.za>
To: "enediel" <enediel@com.ith.tur.cu>; "postgresql"
<pgsql-general@postgresql.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
>
