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.