diff options
| author | Bruce Momjian <bruce@momjian.us> | 2023-11-17 16:46:43 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2023-11-17 16:47:04 -0500 |
| commit | 8127e6e8ada675f5212e8ffac8cfb9ebaa0fe845 (patch) | |
| tree | a1560d47953c3ecba43529f9997704aab9bf0e92 /doc/src | |
| parent | b2e237afddc56a4826121169a693412d8683d940 (diff) | |
| download | postgresql-8127e6e8ada675f5212e8ffac8cfb9ebaa0fe845.tar.gz postgresql-8127e6e8ada675f5212e8ffac8cfb9ebaa0fe845.zip | |
doc: update query section to show LIMIT/OFFSET like SELECT
The parameter names were slightly better in SELECT, so make them match.
Reported-by: Euler Taveira
Discussion: https://postgr.es/m/CAHE3wgh-EYuAbLG1VS3QTHii1TgWS31h-fYEgrdda7oTOuskOQ@mail.gmail.com
Backpatch-through: master
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/queries.sgml | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 8a4674e5f28..648b283b064 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1912,7 +1912,8 @@ SELECT a + b AS sum, c FROM table1 ORDER BY sum + c; -- wrong SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression</replaceable> <optional> ORDER BY ... </optional> - <optional> LIMIT { <replaceable>number</replaceable> | ALL } </optional> <optional> OFFSET <replaceable>number</replaceable> </optional> + <optional> LIMIT { <replaceable class="parameter">count</replaceable> | ALL } </optional> + <optional> OFFSET <replaceable class="parameter">start</replaceable> </optional> </synopsis> </para> |