In my table, a TEXT column is a unique column, by default it allows "denis"
and "DENIS" to be entered in same column.
I want the database to ignore CASE for considering uniqueness of the data.
for e.g. once "Denis" is entered, it should not allow to enter "denis",
"Denis", "DENIS" , "DeNiS" ...
In response to
pgsql-novice by date
|Next:||From: devi||Date: 2002-04-18 06:54:54|
|Subject: How to check success/failure of dml statements|
|Previous:||From: denis||Date: 2002-04-18 05:27:03|
|Subject: Re: Newbie in functions|