]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Update GROUP BY ALL comments about window functions
authorPeter Eisentraut <peter@eisentraut.org>
Tue, 7 Jul 2026 06:37:15 +0000 (08:37 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Tue, 7 Jul 2026 06:47:07 +0000 (08:47 +0200)
commit2ce74583652fb4cd29299a220ff31043adf5c96e
treee720d87b9dcb84e6f818c4591f472523f953bba4
parent4c75cc786301886145bc1a450977cbd024814ef5
Update GROUP BY ALL comments about window functions

When GROUP BY ALL was added in commit ef38a4d9756, the SQL standard
working draft was silent on what to do with window functions.  This
has now been fixed in the SQL standard working draft.  Update the
documentation and code comments about that.

Also make the documentation more specific that we are only talking
about aggregate functions referring to the same query level, which is
another thing that has been made more precise in the SQL standard
working draft since.

The PostgreSQL implementation was already doing the right thing for
both aspects, so no functionality changes.

Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://www.postgresql.org/message-id/flat/CAHM0NXjz0kDwtzoe-fnHAqPB1qA8_VJN0XAmCgUZ%2BiPnvP5LbA%40mail.gmail.com
doc/src/sgml/queries.sgml
doc/src/sgml/ref/select.sgml
src/backend/parser/parse_clause.c