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