Home > mailing lists

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

From	Jelte Fennema-Nio
Subject	Re: [PATCH] GROUP BY ALL
Date	August 17 20:12:51
Msg-id	CAGECzQSGKWy1tcB8BB=p2suOvW0KLtLR+pm=XTagfp9WSA4HXQ@mail.gmail.com Whole thread Raw
In response to	Re: [PATCH] GROUP BY ALL (Peter Eisentraut <peter@eisentraut.org>)
List	pgsql-hackers

Tree view

On Tue, 23 Jul 2024 at 22:02, Peter Eisentraut <peter@eisentraut.org> wrote:
> Looks like the main existing implementations take it to mean all entries
> in the SELECT list that are not aggregate functions.
>
> https://duckdb.org/docs/sql/query_syntax/groupby.html#group-by-all
> https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-groupby.html#parameters
> https://docs.snowflake.com/en/sql-reference/constructs/group-by#parameters

Oracle added support for GROUP BY ALL too now:
https://danischnider.wordpress.com/2025/08/05/oracle-23-9-supports-group-by-all/

pgsql-hackers by date:

From: Tom Lane
Date: 17 August, 18:19:22
Subject: Re: psql: Count all table footer lines in pager setup

From: Peter Geoghegan
Date: 17 August, 20:30:14
Subject: Re: index prefetching

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

Previous

Next