pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedexamples for windows functions
3+ messages / 2 participants
[nested] [flat]
* examples for windows functions
@ 2023-10-02 11:42 Giampaolo Capelli <giampow@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Giampaolo Capelli @ 2023-10-02 11:42 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: examples for windows functions
@ 2023-10-02 14:24 Tom Lane <tgl@sss.pgh.pa.us>
parent: Giampaolo Capelli <giampow@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2023-10-02 14:24 UTC (permalink / raw)
To: giampow@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
Giampaolo Capelli <giampow@gmail.com> writes:
> 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
That page starts out with a link to section 3.5 which is
full of examples. Seems a bit repetitive to put more here.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: examples for windows functions
@ 2023-10-02 15:22 Giampaolo Capelli <giampow@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Giampaolo Capelli @ 2023-10-02 15:22 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs@lists.postgresql.org
Ok, but in section 3.5 I don't see examples on the "preceeding" clause.
What about enriching the section 3.5 then?
<tgl@sss.pgh.pa.us>:
> Giampaolo Capelli <giampow@gmail.com> writes:
> > 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
>
> That page starts out with a link to section 3.5 which is
> full of examples. Seems a bit repetitive to put more here.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-10-02 15:22 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-02 11:42 examples for windows functions Giampaolo Capelli <giampow@gmail.com>
2023-10-02 14:24 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-10-02 15:22 ` Giampaolo Capelli <giampow@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox