"Bruce Momjian" <bruce@momjian.us> writes:
>> Fwiw even in the min/max/sum case the spec is moving away from having
>> aggregates ignore NULL values. You now get a warning in Oracle if your
>> aggregate includes any NULL inputs.
>
> How does Oracle's new behavior relate to the standard moving?
Sorry I noticed that editing error only after I sent it. I should have changed
that to say Oracle was moving in that direction. There's nothing of the sort
in SQL2003 that I can find.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com