Postgres Pro
Downloads
Home   >   mailing lists

Re: unclear syntax explanation for multiple window definitions in a SELECT query - Mailing list pgsql-docs

From David G. Johnston
Subject Re: unclear syntax explanation for multiple window definitions in a SELECT query
Date
Msg-id CAKFQuwYx9wD59YjJ+OYf7JQ5WP7eN1FP9ktdGYBNk-QXFvDhnw@mail.gmail.com
Whole thread Raw
In response to Re: unclear syntax explanation for multiple window definitions in a SELECT query  (Adam Mackler <adam@mackler.email>)
List pgsql-docs
Tree view
On Thu, Feb 16, 2023 at 10:18 AM Adam Mackler <adam@mackler.email> wrote:

Maybe the reference section for SELECT is the wrong place for that longer form, but section 4.2.8 (or some other referenced from there) could be.


Expanding Section 7.2.5 to be more consistent in level-of-detail with the rest of that page (syntax and examples in particular) seems like an easy sell.
https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-WINDOW

I'm not convinced that modifying the SELECT page to make all of the relevant [, ...] items [, blah-blah-blah ] instead is going to be a net improvement.

David J.

pgsql-docs by date:

Previous
From: Adam Mackler
Date:
Subject: Re: unclear syntax explanation for multiple window definitions in a SELECT query
Next
From: PG Doc comments form
Date:
Subject: Transaction wraparound and read committed isolation level