Re: NULLs: theoretical problems?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Wed, 08 Aug 2007 09:26:08 -0300
Message-ID: <46b9b627$0$4048$9a566e8b@news.aliant.net>

sinister wrote:

> 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.

The ultimate theoretical problem is a complete lack of any theory underpinning NULL. Received on Wed Aug 08 2007 - 07:26:08 CDT