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