Missing documentation for FETCH FIRST in chapter 7.6
Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.
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.