null = null - Mailing list pgsql-sql

From chester c young
Subject null = null
Date
Msg-id 20020119163946.8413.qmail@web12708.mail.yahoo.com
Whole thread Raw
Responses Re: null = null  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
the following took me by suprise:

egg=# select null=null;?column?
----------t

if this were true, for example, then only one null key could be in a
unique index, which is certainly not true.

i thought the philosphical idea behind null in SQL was you didn't know,
which can't have equivalence (as versus the pragmatic idea in C where
null is a dead end pointer, which can have equivalence).  or have I
been too involved with my Oracle databases?


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/


pgsql-sql by date:

Previous
From: Murray Prior Hobbs
Date:
Subject: Re: pltlc and pltlcu problems
Next
From: Tom Lane
Date:
Subject: Re: pltlc and pltlcu problems