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: vc <boston103_at_hotmail.com>
Date: 27 Nov 2005 09:54:01 -0800
Message-ID: <1133114041.839154.239970@g47g2000cwa.googlegroups.com>


Jon Heggland wrote:
[...]
>
> I prefer to avoid NULLs altogether. But as I'm sure you know, even SQL
> considers NULLs equal in many circumstances.

Well, I do not know that. Could you give an example other than "order by" (which by the way does not involve comparison between null attributes at least at the logical level) ?

>
> > If not so, why do we
> > need to modify our query at all ? The standard SQL does not evaluate
> > null=null to true, so why bother writing the query "so as to disregard
> > people with NULL country" ?
>
> To avoid 3VL.

If you said, "to avoid 3vl SQL implementation inconsistencies", I'd agree ;)

> --
> Jon
Received on Sun Nov 27 2005 - 11:54:01 CST

Original text of this message

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