Postgres Pro
Downloads
Home   >   mailing lists

Re: GROUP BY ALL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: GROUP BY ALL
Date
Msg-id 835590.1671424214@sss.pgh.pa.us
Whole thread Raw
In response to GROUP BY ALL  (Andrey Borodin <amborodin86@gmail.com>)
Responses Re: GROUP BY ALL  (Andrey Borodin <amborodin86@gmail.com>)
Re: GROUP BY ALL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: GROUP BY ALL  (Isaac Morland <isaac.morland@gmail.com>)
List pgsql-hackers
Tree view 
Andrey Borodin <amborodin86@gmail.com> writes:
> I saw a thread in a social network[0] about GROUP BY ALL. The idea seems useful.

Isn't that just a nonstandard spelling of SELECT DISTINCT?

What would happen if there are aggregate functions in the tlist?
I'm not especially on board with "ALL" meaning "ALL (oh, but not
aggregates)".

            regards, tom lane

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: (non) translatable string splicing
Next
From: Andrey Borodin
Date:
Subject: Re: GROUP BY ALL