Re: greatest/least semantics different between oracle and postgres

"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