Gregory Stark wrote: > "Tom Lane" <[EMAIL PROTECTED]> writes: > > > GREATEST/LEAST aren't in the spec, so there's not much help there. > > > > Except ... if they ever do get added to the spec, what do you think > > the spec will say? The odds it'd contradict Oracle seem about nil. > > 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? -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
