doubts about a constraint's definition

From: "enediel" <enediel(at)com(dot)ith(dot)tur(dot)cu>
To: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: doubts about a constraint's definition
Date: 2003-03-21 17:08:32
Message-ID: 005601c2efcc$81b8e460$2824a8c0@nsoft
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Flower Sun 2003-03-21 17:15:05 phpPgAdmin setup on windows
Previous Message Dann Corbit 2003-03-21 17:05:38 Re: FIPS 127-2