Re: Oracle 7.1 Enhancements
From: Mark Miller <mem8321_at_u.cc.utah.edu>
Date: 17 Jun 1994 20:03:23 -0600
Message-ID: <2ttklb$kso_at_u.cc.utah.edu>
Date: 17 Jun 1994 20:03:23 -0600
Message-ID: <2ttklb$kso_at_u.cc.utah.edu>
In my opinion the SQL treatment of NULLS has a few serious flaws.
NULL should be treated like an empty set in set algebra.
e.g. ( column <> B ) should be true if column is NULL.
Otherwise NOT ( column <> B ) does not equal ( column = B ).
NULL should behave like a value that is equal to nothing and unequal to everything.
I welcome your comments. Received on Sat Jun 18 1994 - 04:03:23 CEST