"Bruce Momjian" <bruce@xxxxxxxxxx> 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