| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: So what's null then if it's not nothing?
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.
-- JonReceived on Tue Dec 20 2005 - 11:00:04 CST
![]() |
![]() |