Re: NULLs: theoretical problems?

From: Gene Wirchenko <>
Date: Fri, 24 Aug 2007 14:33:17 -0700
Message-ID: <>

Ed Prochak <> wrote:


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


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