Home > mailing lists

Primary Key - Mailing list pgsql-novice

From	denis@coralindia.com
Subject	Primary Key
Date	April 18, 2002 05:50:37
Msg-id	004401c1e69a$4f441ae0$0232a8c0@coralindia.com Whole thread Raw
In response to	Coalesce with Timestamp,Nulls,and Concatenation (Pam Wampler <Pam_Wampler@taylorwhite.com>)
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: "Joshua b. Jore"
Date: 18 April 2002, 02:20:50
Subject: Re: writing to file

From: denis@coralindia.com
Date: 18 April 2002, 05:50:58
Subject: Re: Newbie in functions

Primary Key - Mailing list pgsql-novice

Previous

Next