Re: Re Wher != and NULLS

Peter Wages (pmwages@cais.com) wrote: : Doesn't NULL mean the absence of value. That is different from : unknown . Unknown implies that a field has a value, except nobody knows : what it is. Absence of value means that something definetly has no value. For a sustained, vitriolic and (finally) quixotic coverage of this entire topic. #include <cjdate.h> "Many readers will know that I am opposed to the 3VL approach. And out of all the the reasons for my opposition, the most important one is wrong answers. It bothers me a great deal -- and it should bother you too -- that we are getting wrong answers out of our SQL system." Date, C. J. _Relational_Database_:_Writings_1991_-_1994_ Addison-Wesley Publishing. Menlo Park. 1995. And almost everywhere else he's every written. He's right, but it's like being the fastest slug on the road in front of the steam-roller. ===================================================================== Paul Brown ^..^ pbrown@postgres.Berkeley.EDU (oo) - Oink! #include <std_disclaimer.h> "Think global - act loco!" - Zippy the Pinhead =====================================================================