Re: So what's null then if it's not nothing?

In article <1134998757.235632.273440_at_z14g2000cwz.googlegroups.com>, boston103_at_hotmail.com says...
>
> So what happens when you have an expression TRUE OR X and X happens to
> be NULL ?
> Or something like (age < 30) or (occupation = 'student') where
> occupation happens to be NULL ? Would an exception be thrown, or would
> the entire expression evaluate to NULL ?

Yes. :) The exception being that the entire expression is considered null.  

> Admittedly, it is easier if null
> > propagates even in the face of "FALSE AND X" and "TRUE OR X". Which, by
> > the way, there is precedent for in several programming languages: In
> > Java, "true | booleanMethod()" does not necessarily evaluate to true.
>
> For example ?

If booleanMethod() throws an exception.

-- 
Jon