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:15 +0000 (10:22 -0400)
commit0f27bd14e48026fe4ddf131a531b230680868aaf
treef471e21a48e26a428dd5373225ad4f98c9a66496
parent43847dd5e93816ef6e37dfb6c8bb7f98f48ddc01
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