Re: 8.1 Unique Index Issue/Bug???

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.1 Unique Index Issue/Bug???
Date: 2006-07-13 19:15:18
Message-ID: 60wtahpb95.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

jd(at)commandprompt(dot)com ("Joshua D. Drake") writes:
> That is why IS NULL can be placed in a unique index because it isn't
> actually there (in the theorectical sense).

In effect, NULL is not actually a value.
--
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://www.ntlug.org/~cbbrowne/sap.html
"Has anyone ever thought about the fact that in general, the only web
sites that are consistently making money are the ones dealing in
pornography? This brings new meaning to the term, "obscene
profits". :)" -- Paul Robinson <postmaster(at)paul(dot)washington(dot)dc(dot)us>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2006-07-13 22:45:46 Re: [ADMIN] Restore Database
Previous Message Joshua D. Drake 2006-07-13 18:44:42 Re: 8.1 Unique Index Issue/Bug???