Re: NULLs: theoretical problems?

From: Gene Wirchenko <genew_at_ocis.net>
Date: Fri, 24 Aug 2007 14:33:17 -0700
Message-ID: <jhjuc351k5lf35mplbsl7t491182jpiuct_at_4ax.com>


Ed Prochak <edprochak_at_gmail.com> wrote:

[snip]

>I wonder how much of these discussions on NULL are echoes of
>discussions about numbers when ZERO was first introduced? Both are a
>practical solution to realworld business problems. 8^)
>
>How's this proposition?
>NULL can only be totally eliminated in a static database. Real world
>production databases need to deal with the situation of "we just don't
>know yet!", so we'll always have NULL.
>
>just some thoughts from a simple non-theorist.

     So create a table of stuff that we do not know about yet; IOW, a to-do list. No NULL required.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.
Received on Fri Aug 24 2007 - 23:33:17 CEST

Original text of this message