Skip site navigation (1) Skip section navigation (2)

Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alban Hertroys <alban(at)magproductions(dot)nl>
Cc: Vivek Khera <vivek(at)khera(dot)org>, Postgresql-General General <pgsql-general(at)postgresql(dot)org>
Subject: Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat
Date: 2006-02-16 17:17:42
Message-ID: 29308.1140110262@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Alban Hertroys <alban(at)magproductions(dot)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

In response to

pgsql-general by date

Next:From: Richard HuxtonDate: 2006-02-16 17:32:07
Subject: Re: address matching and verification
Previous:From: Nels LindquistDate: 2006-02-16 16:58:36
Subject: Re: Minor Releases 7.3 thru 8.1 Available to Fix Security

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group