| From: | Vik Fearing <vik(at)postgresfriends(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Cc: | David Christensen <david(at)pgguru(dot)net>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl> |
| Subject: | Re: [PATCH] GROUP BY ALL |
| Date: | 2025-09-27 18:14:58 |
| Message-ID: | 6db86e0b-697a-4e4b-860a-7ad9736a8e81@postgresfriends.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 27/09/2025 18:03, Tom Lane wrote:
> So according to the standard, this:
>
> select a+b, count(*) from ... group by all;
>
> would be invalid because a+b couldn't be written directly in
> GROUP BY?
Correct.
> I can't see us rejecting that though, since we do
> allow a+b in GROUP BY.
No, nor do I. Also, there were rumors about adding expressions to group
by in the standard but no formal proposal yet.
FWIW, I opposed adding this GROUP BY ALL feature, but I was
outnumbered. I hope to never see it in production.
--
Vik Fearing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arseniy Mukhin | 2025-09-27 18:39:07 | Re: BackgroundPsql swallowing errors on windows |
| Previous Message | Sami Imseih | 2025-09-27 17:44:23 | Re: [BUG] temporary file usage report with extended protocol and unnamed portals |