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

From: Jon Heggland <heggland_at_idi.ntnu.no>
Date: Tue, 20 Dec 2005 18:00:04 +0100
Message-ID: <MPG.1e1256f379b997b598975d_at_news.ntnu.no>


In article <1135009623.261858.9330_at_g49g2000cwa.googlegroups.com>, boston103_at_hotmail.com says...
>
> So is it your assertion that 2 + X evaluates to NULL if X happens to be
> NULL ? If so, what is '+' then ?

'+' is irrelevant. :) In any case, I'm not interested in defending how SQL NULLs work.

> > If booleanMethod() throws an exception.
>
> One can give at least two possible answers to that:
> [8<]
> Sort of obvious, no ?

So what? And what's with the snarkiness?

Minor nitpick, by the way: "true || booleanMethod()" *will* return true, due to shortcut evaluation---booleanMethod will not be called. I used the '|' (single bar) operator on purpose. One could do something similar in an SQL-like language, though it would inhibit the optimiser, of course.

-- 
Jon
Received on Tue Dec 20 2005 - 18:00:04 CET

Original text of this message