null = null

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/