]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: improve description of window function processing.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 10 Mar 2025 14:22:08 +0000 (10:22 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 10 Mar 2025 14:22:26 +0000 (10:22 -0400)
commit2db974e40df64b946e172736547f001162439149
tree61c5af3215756ca4e723583956390a5261bb236b
parente2921c0e9de3c153b9d75d1fcf219afce42f64c7
Doc: improve description of window function processing.

The previous wording talked about a "single pass over the data",
which can be read as promising more than intended (to wit, that only
one WindowAgg plan node will be used).  What we promise is only what
the SQL spec requires, namely that the data not get re-sorted between
window functions with compatible PARTITION BY/ORDER BY clauses.
Adjust the wording in hopes of making this clearer.

Reported-by: Christopher Inokuchi <cinokuchi@gmail.com>
Author: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>
Discussion: https://postgr.es/m/CABde6B5va2wMsnM79u_x=n9KUgfKQje_pbLROEBmA9Ru5XWidw@mail.gmail.com
Backpatch-through: 13
doc/src/sgml/queries.sgml