Re: 8.1 Unique Index Issue/Bug??? - Mailing list pgsql-admin

From Chris Browne
Subject Re: 8.1 Unique Index Issue/Bug???
Date
Msg-id 60wtahpb95.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to 8.1 Unique Index Issue/Bug???  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
jd@commandprompt.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@paul.washington.dc.us>

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: 8.1 Unique Index Issue/Bug???
Next
From: Alexander Burbello
Date:
Subject: Re: Restore Database