Re: Adding UNIQUE constraint on NULL column

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

Dave Smith <dave(dot)smith(at)candata(dot)com> writes:

> On Thu, 2005-01-13 at 10:12, Doug McNaught wrote:

>> Are you really saying that you want 'NULL = NULL' to return 't'?

> Yes

Well, that's not how NULL works.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-13 17:09:41 Re: vacuum vs open transactions
Previous Message Michael Fuhr 2005-01-13 17:02:16 Re: vacuum vs open transactions