| From: | Jelte Fennema-Nio <postgres(at)jeltef(dot)nl> |
|---|---|
| To: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, David Christensen <david(at)pgguru(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] GROUP BY ALL |
| Date: | 2025-08-17 17:12:51 |
| Message-ID: | CAGECzQSGKWy1tcB8BB=p2suOvW0KLtLR+pm=XTagfp9WSA4HXQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 23 Jul 2024 at 22:02, Peter Eisentraut <peter(at)eisentraut(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2025-08-17 17:30:14 | Re: index prefetching |
| Previous Message | Tom Lane | 2025-08-17 15:19:22 | Re: psql: Count all table footer lines in pager setup |