Re: Adding UNIQUE constraint on NULL column

From: Dave Smith <dave(dot)smith(at)candata(dot)com>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Adding UNIQUE constraint on NULL column
Date: 2005-01-13 15:13:30
Message-ID: 1105629210.17154.15.camel@playpen.candata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes
On Thu, 2005-01-13 at 10:12, Doug McNaught wrote:
> Dave Smith <dave(dot)smith(at)candata(dot)com> writes:
>
> > 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?
>
> UNIQUE constraints on NULLable columns work fine. It's not clear from
> the above what you're looking for.
>
> Are you really saying that you want 'NULL = NULL' to return 't'?
>
> -Doug
--
Dave Smith
CANdata Systems Ltd
416-493-9020

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bsimon 2005-01-13 15:23:29 Réf. : Re: Réf. : Debugging SPI C functions
Previous Message Doug McNaught 2005-01-13 15:12:32 Re: Adding UNIQUE constraint on NULL column