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

Reply via email to