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>
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.
>
> 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.
-- JonReceived on Tue Dec 20 2005 - 18:00:04 CET