doubts about a constraint's definition - Mailing list pgsql-general

From enediel
Subject doubts about a constraint's definition
Date
Msg-id 005601c2efcc$81b8e460$2824a8c0@nsoft
Whole thread Raw
Responses Re: doubts about a constraint's definition  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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!


pgsql-general by date:

Previous
From: Georgi Chorbadzhiyski
Date:
Subject: Re: rules problem
Next
From: "enediel"
Date:
Subject: Re: doubts about a constraint's definition