Hello,
I'd like to propose to add some examples to the following page
https://www.postgresql.org/docs/16/functions-window.html
The syntax of window functions is fully covered by the page
https://www.postgresql.org/docs/16/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS
but I think it would be helpful to put some examples in
https://www.postgresql.org/docs/16/functions-window.html
Some example showing the use of preceding would be useful, like the
following
over (partition by col1 order by col2
rows between 10 preceding and 1 preceding
)
what do you think?
Thank you,
best regards