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: David Cressey <david.cressey_at_earthlink.net>
Date: Thu, 24 Nov 2005 13:14:30 GMT
Message-ID: <W0jhf.4894$N45.1944@newsread1.news.atl.earthlink.net>

"JOG" <jog_at_cs.nott.ac.uk> wrote in message news:1132798136.903908.163790_at_f14g2000cwb.googlegroups.com...
> Look, when you create a relation, you are defining a predicate. You are
> saying propositions that fit with these variables will be stored here.
> If you have proposition that does not fit due to absent information,
> and you try to insert it, you are trying to put a square peg in a round
> hole. That proposition DOES NOT MATHEMATICALLY BELONG THERE. It doesn't
> fulfill the predicate. Full stop.

Warning: humor follows.

It's easy to put a square peg in a round hole. All you need are four NULLS that are shaped like a slice of a cylinder with a segment shaped cross section, each spanning 90 degrees. You fit the four NULLS into the round hole, and what remains forms a square gap, into which the square peg fits perfectly! Received on Thu Nov 24 2005 - 07:14:30 CST

Original text of this message

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