Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group