On Thu, Sep 7, 2023 at 10:11:00AM -0400, Bruce Momjian wrote: > We do farther down the docs in the GROUP BY section: > > https://www.postgresql.org/docs/devel/sql-select.html > > GROUP BY will condense into a single row all selected rows that share > the same values for the grouped expressions. An expression used inside a > grouping_element can be an input column name, or the name or ordinal > number of an output column (SELECT list item), or an arbitrary > expression formed from input-column values. In case of ambiguity, a > ------------------------ > GROUP BY name will be interpreted as an input-column name rather than an > output column name. > > It says > > * input column name > * output column name or ordinal number > * expression formed from input-column values > > Is this too subtle?
Patch applied back to PG 11. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
