diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-12-01 16:39:07 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-12-01 16:39:07 -0500 |
| commit | da1eacb8d2cebc5b43bbe2c93f1c74c962182ae5 (patch) | |
| tree | 9c8558fb54efd56f7719c82673df089a3556202b | |
| parent | 698bb4ec4f3f57df4d2c006a0f90552ab584b501 (diff) | |
| download | postgresql-da1eacb8d2cebc5b43bbe2c93f1c74c962182ae5.tar.gz postgresql-da1eacb8d2cebc5b43bbe2c93f1c74c962182ae5.zip | |
Clarify documentation about SQL:2008 variant of LIMIT/OFFSET syntax.
The point that you need parentheses for non-constant expressions apparently
needs to be brought out a bit more clearly, per bug #6315.
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 15d9b75b59b..3fbfda309e2 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1056,17 +1056,19 @@ OFFSET <replaceable class="parameter">start</replaceable> OFFSET <replaceable class="parameter">start</replaceable> { ROW | ROWS } FETCH { FIRST | NEXT } [ <replaceable class="parameter">count</replaceable> ] { ROW | ROWS } ONLY </synopsis> - According to the standard, the <literal>OFFSET</literal> clause must come - before the <literal>FETCH</literal> clause if both are present; but - <productname>PostgreSQL</> is laxer and allows either order. + In this syntax, to write anything except a simple integer constant for + <replaceable class="parameter">start</> or <replaceable + class="parameter">count</replaceable>, you must write parentheses + around it. + If <replaceable class="parameter">count</> is + omitted in a <literal>FETCH</> clause, it defaults to 1. <literal>ROW</literal> and <literal>ROWS</literal> as well as <literal>FIRST</literal> and <literal>NEXT</literal> are noise words that don't influence - the effects of these clauses. In this syntax, when using expressions - other than simple constants for <replaceable class="parameter">start</> - or <replaceable class="parameter">count</replaceable>, parentheses will be - necessary in most cases. If <replaceable class="parameter">count</> is - omitted in <literal>FETCH</>, it defaults to 1. + the effects of these clauses. + According to the standard, the <literal>OFFSET</literal> clause must come + before the <literal>FETCH</literal> clause if both are present; but + <productname>PostgreSQL</> is laxer and allows either order. </para> <para> |