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
