Re: GROUP BY ALL

On 12/19/22 05:19, Andrey Borodin wrote:
> Hi hackers!
>
> I saw a thread in a social network[0] about GROUP BY ALL. The idea seems useful.
> I always was writing something like
> select datname, usename, count(*) from pg_stat_activity group by 1,2;
> and then rewriting to
> select datname, usename, query, count(*) from pg_stat_activity group by 1,2;
> and then "aaahhhh, add a number at the end".
>
> With the proposed feature I can write just
> select datname, usename, count(*) from pg_stat_activity group by all;

We already have GROUP BY ALL, but it doesn't do this.

> PFA very dummy implementation just for a discussion. I think we can
> add all non-aggregating targets.
>
> What do you think?

I think this is a pretty terrible idea. If we want that kind of
behavior, we should just allow the GROUP BY to be omitted since without
grouping sets, it is kind of redundant anyway.

I don't know what my opinion is on that.
--
Vik Fearing