"Mark Hollomon" <mhh(at)nortelnetworks(dot)com> writes:
> select distinct on (c, i) c, count(i) from t group by c;
> ERROR: Attribute t.i must be GROUPed or used in an aggregate function
Why do you think that's a bug? The DISTINCT clause requires use of
the ungrouped value of i, doesn't it?
regards, tom lane