Primary Key

From: denis(at)coralindia(dot)com
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Primary Key
Date: 2002-04-18 05:31:35
Message-ID: 004401c1e69a$4f441ae0$0232a8c0@coralindia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

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" ...

Thanks

Denis

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message devi 2002-04-18 06:54:54 How to check success/failure of dml statements
Previous Message denis 2002-04-18 05:27:03 Re: Newbie in functions