Home > mailing lists

[PATCH] GROUP BY ALL - Mailing list pgsql-hackers

From	David Christensen
Subject	[PATCH] GROUP BY ALL
Date	July 22 23:55:20
Msg-id	CAHM0NXjz0kDwtzoe-fnHAqPB1qA8_VJN0XAmCgUZ+iPnvP5LbA@mail.gmail.com Whole thread Raw
Responses	Re: [PATCH] GROUP BY ALL Re: [PATCH] GROUP BY ALL
List	pgsql-hackers

Tree view

I see that there'd been some chatter but not a lot of discussion about
a GROUP BY ALL feature/functionality.  There certainly is utility in
such a construct IMHO.

The grammar is unambiguous, so can support this construct in lieu of
the traditional GROUP BY clause.  Enclosed is a patch which adds this
via just scanning the TargetEntry list and adding anything that is not
an aggregate function call to the groupList.

Still need some docs; just throwing this out there and getting some feedback.

Thanks,

David

Attachment

0001-WIP-groupAll-to-automatically-add-columns-to-the-gro.patch

pgsql-hackers by date:

From: Nathan Bossart
Date: 22 July, 23:07:10
Subject: Re: optimizing pg_upgrade's once-in-each-database steps

From: Masahiko Sawada
Date: 22 July, 23:59:10
Subject: Re: Use pgBufferUsage for block reporting in analyze

[PATCH] GROUP BY ALL - Mailing list pgsql-hackers

Attachment

Previous

Next