Tom Lane wrote:
> Anyway, there's no doubt that we can point to the behavior of MAX/MIN
> as defense for what we made GREATEST/LEAST do, so I'm inclined to
> leave
> their behavior alone, at least until such time as they're actually
> standardized.
I don't think I buy this - MIN and MAX are aggregates, GREATEST is
just a function, yes? There would seem to be a very strong analogy
with SUM and the addition function, yet 2 + NULL is NULL, while SUM
ignores NULLs. (Not in front of a console, sorry if I'm mistaken.)
- John Burger
MITRE