Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat - Mailing list pgsql-general

From Tom Lane
Subject Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat
Date
Msg-id 29308.1140110262@sss.pgh.pa.us
Whole thread Raw
In response to Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Alban Hertroys <alban@magproductions.nl> writes:
> I suspect they have some pretty good reasons to treat NULL values in a
> UNIQUE constraint as different even from other NULL values. It sure
> makes me curious though ;)

Date & Darwen make it pretty clear that they think this sucks, and in
fact that they think SQL's definition of nulls sucks in general.  But
that's how the spec is written.

            regards, tom lane

pgsql-general by date:

Previous
From: Nels Lindquist
Date:
Subject: Re: Minor Releases 7.3 thru 8.1 Available to Fix Security
Next
From: Richard Huxton
Date:
Subject: Re: address matching and verification