Re: GROUP BY ALL - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: GROUP BY ALL
Date
Msg-id CAAhFRxiA_K6b4ps30Q623z7Xvc+whsr4wfKmtH0Vshsg3B7ThA@mail.gmail.com
Whole thread Raw
In response to Re: GROUP BY ALL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Dec 18, 2022 at 8:30 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> I'm not especially on board with "ALL" meaning "ALL (oh, but not
> aggregates)".

Yes, that's the weak part of the proposal. I even thought about
renaming it to "GROUP BY SOMEHOW" or even "GROUP BY SURPRISE ME".
I mean I see some cases when it's useful and much less cases when it's
dangerously ambiguous. E.g. grouping by result of a subquery looks way
too complex and unpredictable. But with simple Vars... what could go
wrong?

Best regards, Andrey Borodin.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: GROUP BY ALL
Next
From: "David G. Johnston"
Date:
Subject: Re: GROUP BY ALL