Re: select null + 0 question

Jean-Christian Imbeault wrote:
> Shouldn't the sum() and "+" operators behave the same?

No, see SQL99, Section 6.16, General Rules 1.b:

"Otherwise, let TX be the single-column table that is the result of
applying the <value expression> to each row of T and eliminating null
values. If one or more null values are eliminated, then a completion
condition is raised: warning — null value eliminated in set function."

I've never seen a database that emits the required warning, though.

Joe