On 2/13/15 1:48 PM, Jeff Janes wrote:
> I waste an inordinate amount of time retyping select lists over into the
> group by list, or copying and pasting and then deleting the aggregate
> clauses. It is an entirely pointless exercise. I can't fault
> PostgreSQL for following the standard, but its too bad the standards
> aren't more sensible.
An extension like GROUP BY ALL might be useful, without breaking much.
Also note that you can group by primary key only.
