Re: Warning about null and open question to Oracle

In article <3smb49$r1j_at_newsbf02.news.aol.com>, barberl_at_aol.com (Barberl) writes:
|> If Oracle's treatment of nulls is consistent with pure math, then why does
|> a boolean have 3 possible values: true,false, and null. There is no math
|> that supports such an idiotic treatment.

See any book on basic logic.

The value may be "true", it may be "false", or you may not know what it is ("indeterminate", "undetermined", or "null").

Those are the three possible states of a boolean value.

   ... Hank

-- 

Hank Oredson _at_ Mentor Graphics             Library Operations
Internet     : hank_oredson_at_mentorg.com    "Parts 'R Us!"
Amateur Radio: W0RLI_at_W0RLI.OR.USA.NOAM