-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, Oct 23, 2001 at 11:56:39PM +0200, Bart Lateur wrote: > My personal opinion is to disagree. To me, NULL means "empty". It is not > the same as a zero length string.
When did I say it was? In fact, I thought I explicitly stated that Oracle was wrong in this regard. A zero-length string is very different from the concept of NULL, which is "no value known". Zero-length string, OTOH, is a known value, one with no characters. > But empty is empty, thus NULL=NULL. > > Nitpicking that NULL != NULL, is only making our life harder. > > Last week, there was a similar discussion going on, on the Perl6 mailing > lists, with regards to NaN (Not A Number). Is NaN==Nan, or NaN!=NaN? ANSI is correct in the case of NULL. If something has no value, how can you equivocably say that it's equal to anything, even something else with no value? And if you say the value is empty then the value isn't NULL because you *know* the value; it's a zero-length string. So the whole argument becomes moot anyway. Of course, if you're using Oracle, '' gets treated as NULL, but that's their fault. (I'd wager this whole thread stems from an Oracle user to start with :) Perhaps they'll finally retire that broken behavior in version 10. Of course, they said they were going to do it in version 8.... - -- Stephen Clouse <[EMAIL PROTECTED]> Senior Programmer, IQ Coordinator Project Lead The IQ Group, Inc. <http://www.theiqgroup.com/> -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQA/AwUBO9XquwOGqGs0PadnEQLNWwCgi16nojePo2E4tHzlKlVi1whTrioAoKzT W0P+kERK+EyKll34RyLXSwb3 =lven -----END PGP SIGNATURE-----
