Re: SELECT, GROUP BY, and aggregates

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.