Missing documentation for FETCH FIRST in chapter 7.6
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/queries-limit.html
Description:
The documentation of the SELECT statement lists FETCH FIRST/OFFSET as an
alternative to the proprietary LIMIT clause.
https://www.postgresql.org/docs/current/static/sql-select.html#SQL-LIMIT
However, chapter 7.6 about LIMIT/OFFSET does not mention the alternative.
https://www.postgresql.org/docs/current/static/queries-limit.html
2018-05-16 10:22 GMT-03:00 PG Doc comments form <noreply@postgresql.org>:
The documentation of the SELECT statement lists FETCH FIRST/OFFSET as an
alternative to the proprietary LIMIT clause.https://www.postgresql.org/docs/current/static/sql-select.html#SQL-LIMIT
However, chapter 7.6 about LIMIT/OFFSET does not mention the alternative.
https://www.postgresql.org/docs/current/static/queries-limit.html
Make sense. I propose the attached patch that adds a link to the LIMIT
section in the SELECT reference page. I also renamed the "number"
variables to the same names used in the SELECT reference page and put
OFFSET in a new line (it looks visually better).
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Attachments:
0001-Add-a-link-to-SELECT-reference-page.patchtext/x-patch; charset=US-ASCII; name=0001-Add-a-link-to-SELECT-reference-page.patchDownload+7-2
On Wed, Jun 13, 2018 at 04:17:55PM -0300, Euler Taveira wrote:
2018-05-16 10:22 GMT-03:00 PG Doc comments form <noreply@postgresql.org>:
The documentation of the SELECT statement lists FETCH FIRST/OFFSET as an
alternative to the proprietary LIMIT clause.https://www.postgresql.org/docs/current/static/sql-select.html#SQL-LIMIT
However, chapter 7.6 about LIMIT/OFFSET does not mention the alternative.
https://www.postgresql.org/docs/current/static/queries-limit.html
Make sense. I propose the attached patch that adds a link to the LIMIT
section in the SELECT reference page. I also renamed the "number"
variables to the same names used in the SELECT reference page and put
OFFSET in a new line (it looks visually better).
I applied the attached patch based on your patch to master. Thanks.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.