diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-07-12 12:28:43 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-07-12 12:29:04 -0400 |
| commit | aacdf9a06966d57bb8f6968a41e0690a31d35a51 (patch) | |
| tree | c70200cdbd0e5e0015041f45523c3227b18e28a4 | |
| parent | 727196ced2423008bb25d7775c4e3b7fca063c8b (diff) | |
| download | postgresql-aacdf9a06966d57bb8f6968a41e0690a31d35a51.tar.gz postgresql-aacdf9a06966d57bb8f6968a41e0690a31d35a51.zip | |
Doc: minor improvement in pl/pgsql FETCH/MOVE documentation.
Explain that you can use any integer expression for the "count" in
pl/pgsql's versions of FETCH/MOVE, unlike the SQL versions which only
allow a constant.
Remove the duplicate version of this para under MOVE. I don't see
a good reason to maintain two identical paras when we just said that
MOVE works exactly like FETCH.
Per Pavel Stehule, though I didn't use his text.
Discussion: https://postgr.es/m/CAFj8pRAcvSXcNdUGx43bOK1e3NNPbQny7neoTLN42af+8MYWEA@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 24 | ||||
| -rw-r--r-- | doc/src/sgml/ref/fetch.sgml | 2 |
2 files changed, 5 insertions, 21 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 5b2aac618e3..d6688e13f48 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -3196,6 +3196,10 @@ FETCH <optional> <replaceable>direction</replaceable> { FROM | IN } </optional> <literal>BACKWARD</literal>. Omitting <replaceable>direction</replaceable> is the same as specifying <literal>NEXT</literal>. + In the forms using a <replaceable>count</replaceable>, + the <replaceable>count</replaceable> can be any integer-valued + expression (unlike the SQL <command>FETCH</command> command, + which only allows an integer constant). <replaceable>direction</replaceable> values that require moving backward are likely to fail unless the cursor was declared or opened with the <literal>SCROLL</literal> option. @@ -3234,26 +3238,6 @@ MOVE <optional> <replaceable>direction</replaceable> { FROM | IN } </optional> < </para> <para> - The <replaceable>direction</replaceable> clause can be any of the - variants allowed in the SQL <xref linkend="sql-fetch"/> - command, namely - <literal>NEXT</literal>, - <literal>PRIOR</literal>, - <literal>FIRST</literal>, - <literal>LAST</literal>, - <literal>ABSOLUTE</literal> <replaceable>count</replaceable>, - <literal>RELATIVE</literal> <replaceable>count</replaceable>, - <literal>ALL</literal>, - <literal>FORWARD</literal> <optional> <replaceable>count</replaceable> | <literal>ALL</literal> </optional>, or - <literal>BACKWARD</literal> <optional> <replaceable>count</replaceable> | <literal>ALL</literal> </optional>. - Omitting <replaceable>direction</replaceable> is the same - as specifying <literal>NEXT</literal>. - <replaceable>direction</replaceable> values that require moving - backward are likely to fail unless the cursor was declared or opened - with the <literal>SCROLL</literal> option. - </para> - - <para> Examples: <programlisting> MOVE curs1; diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index 5ef63f00583..e802be61c8c 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -99,7 +99,7 @@ FETCH [ <replaceable class="parameter">direction</replaceable> [ FROM | IN ] ] < This page describes usage of cursors at the SQL command level. If you are trying to use cursors inside a <application>PL/pgSQL</application> function, the rules are different — - see <xref linkend="plpgsql-cursors"/>. + see <xref linkend="plpgsql-cursor-using"/>. </para> </note> </refsect1> |