examples for windows functions

From: Giampaolo Capelli <giampow(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: examples for windows functions
Date: 2023-10-02 11:42:58
Message-ID: CAJ=H7uy+=+N0RBe9KEpc3yBAwJ7_Fue=MCNuX6Oi=9AFPeNE8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2023-10-02 14:24:13 Re: examples for windows functions
Previous Message David G. Johnston 2023-09-30 21:51:35 Re: missing GRANTED BY explanations