NULLs: theoretical problems?
From: sinister <sinister_at_nospam.invalid>
Date: Wed, 8 Aug 2007 06:43:53 -0400
Message-ID: <wa-dnYfs8-TuAyTbnZ2dnUVZ_tSknZ2d_at_comcast.com>
Many discussions point out one deficiency of NULLs: that they collapse multiple, distinct concepts into one ("no value possible," "value missing," "value not available at this time", etc).
Date: Wed, 8 Aug 2007 06:43:53 -0400
Message-ID: <wa-dnYfs8-TuAyTbnZ2dnUVZ_tSknZ2d_at_comcast.com>
Many discussions point out one deficiency of NULLs: that they collapse multiple, distinct concepts into one ("no value possible," "value missing," "value not available at this time", etc).
What are the other theoretical problems? My impression from skimming some threads in this ng is that some anomalies might occur, maybe having to do with NULLs and joins, or NULLs and keys composed of more than one field, but I'm not sure. Received on Wed Aug 08 2007 - 12:43:53 CEST