Re: [HACKERS] SUM() and GROUP BY

> I suppose you could argue that this is consistent with cases 2 and 3,
> in a weird way, but it's certainly not the way I'd expect it to work.
> If there are no groups created by GROUP BY, then AVG should never be
> invoked at all, therefore there should be no rows returned.

Agreed.

> So, again I agree with D'Arcy.

I'm missing something. Is there another issue for GROUP BY for which we
don't have a consensus? An aggregate on an entire column can return
NULL, and aggregates on columns with GROUP BY columns of NULL should
not.

> But I'm not the one who might have
> to try to fix this...

And why not? :)
                   - Tom