On Sunday, November 10, 2024, PG Doc comments form <
noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/tutorial-window.html
Description:
In Section 3.5 Window Functions, the sentence that currently says:
"As shown here, the rank function produces a numerical rank for each
distinct ORDER BY value in the current row's partition..."
should say:
"As shown here, the rank function produces a numerical rank for each
distinct depname value in the current row's partition..."
https://www.postgresql.org/docs/current/tutorial-window.html
If we wanted to name the relevant column it would be salary, not depname. It is the column(s) in the order by that matter here. Or I suppose the combination of depname and salary. Though it was already covered that each partition resets all aggregates. Here we are not talking about reset but when something increments.
David J.
