Re: So what's null then if it's not nothing?
Date: Thu, 24 Nov 2005 13:14:30 GMT
"JOG" <jog_at_cs.nott.ac.uk> wrote in message
> 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 - 14:14:30 CET