Home > mailing lists

Adding UNIQUE constraint on NULL column - Mailing list pgsql-general

From	Dave Smith
Subject	Adding UNIQUE constraint on NULL column
Date	January 13, 2005 17:01:14
Msg-id	1105624867.17160.9.camel@playpen.candata.com Whole thread Raw
Responses	Re: Adding UNIQUE constraint on NULL column (Doug McNaught <doug@mcnaught.org>) Re: Adding UNIQUE constraint on NULL column (Bruno Wolff III <bruno@wolff.to>)
List	pgsql-general

Tree view

I am trying to add a unique constraint on a column that can be null. The
documentation states that null is treated as non equal values but I want
them to be equal. Is there another way of doing this other than writing
a before insert trigger?

--
Dave Smith
CANdata Systems Ltd
416-493-9020

pgsql-general by date:

From: Greg Stark
Date: 13 January 2005, 16:59:42
Subject: Re: [HACKERS] Much Ado About COUNT(*)

From: Marek Lewczuk
Date: 13 January 2005, 17:14:47
Subject: Trace triggers

Adding UNIQUE constraint on NULL column - Mailing list pgsql-general

Previous

Next