thanks Eric for the answer, but the question is how to keep the
information's integrity without convert strings to upper case.
I need to do that transparent to the user
Greetings
Enediel
Linux user 300141
Happy who can penetrate the secret causes of the things
¡Use Linux!
----- Original Message -----
From: "Eric Déchaux" <edechaux@irci.fr>
To: "enediel" <enediel@com.ith.tur.cu>
Sent: Friday, March 21, 2003 6:14 AM
Subject: Re: [GENERAL] doubts about a constraint's definition
Hello, I think you can 'upcase' the string written by the user before
inserting it into the table.
Le Fri, 21 Mar 2003 09:08:32 -0800
"enediel" <enediel@com.ith.tur.cu> a ecrit :
>Hello:
>I've the following question:
>
>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
>
>
>
>
>
>Thanks in advance for any help
>Enediel
>Linux user 300141
>
>Happy who can penetrate the secret causes of the things
>¡Use Linux!
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
--
Eric Déchaux
IRCI
87 rue Bizet
94800 Villejuif
Tel Poste : +33 (0) 1 47 26 71 03
Tel Standard : +33 (0) 1 47 26 37 73
Email : edechaux@irci.fr
