Re: NULLs: theoretical problems?

From: Jon Heggland <jon.heggland_at_idi.ntnu.no>
Date: Fri, 24 Aug 2007 09:38:41 +0200
Message-ID: <fam1u3$886$1_at_orkan.itea.ntnu.no>


Quoth Keith H Duggar:
> So it's required to "write DEF" for all nullable attributes and a
> formula is true only if the nullable attributes are defined. How
> is this different from dropping the requirement to "write DEF" and
> simply defining that a formula is false if any of it's variables
> is undefined? And how is that different from allowing NULL and
> defining that a formula is false if any variable is NULL?

Note that SQL does not actually do this, and Jan Hidder's example depends on it. TRUE OR NULL is TRUE, not NULL (or FALSE). Would you have it otherwise?

-- 
Jon
Received on Fri Aug 24 2007 - 09:38:41 CEST

Original text of this message