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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general