Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: So what's null then if it's not nothing?

Re: So what's null then if it's not nothing?

From: JOG <jog_at_cs.nott.ac.uk>
Date: 29 Nov 2005 12:46:01 -0800
Message-ID: <1133297161.197857.183420@g14g2000cwa.googlegroups.com>


Gene Wirchenko wrote:
[snip]
> >If what does not exist? You think we should have some special value to
>
> The "something" under discussion.
>
> >represent the "fact" that something doesn't exist? Go on then - be fair
>
> No.
>
> Either:
>
> 1) It does not get recorded since a database is statements of what
> we know, or
> 2) The statement is that we know that we do not know something.
> This is a simple boolean value.

D. Rumsfeld made an incredible quote about all of this. Always worth a google. Now, he was dodging questions about Iraq at the time, but amazingly it applies to databases ;) He said:

Cover these and you have covered it all. Just don't mix them up with flipping nulls unless you really can't help it (i.e. you live in an SQL purgatory with the rest of us). Received on Tue Nov 29 2005 - 14:46:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US