Re: [HACKERS] SUM() and GROUP BY

Thus spake Thomas G. Lockhart
> > 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.

Well, I still think that an aggregate on a whole column when no rows
are selected (None exist or WHERE clause deselects everything) should
return 0 rows, not NULL but the above would be better than what happens
now.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.