diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-09-29 20:05:29 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-09-29 20:05:29 +0000 |
| commit | 960d7ff02266b3e11684470d140ed26957aece5f (patch) | |
| tree | ec6348ffb8e39e7b6f9018defc6127890e3b3859 /doc/src | |
| parent | 25549edb268d5d02de16ce2cab33fee24c6d0873 (diff) | |
Allow MOVE FORWARD n, MOVE BACKWARD n, MOVE FORWARD ALL, MOVE BACKWARD ALL
in plpgsql. Clean up a couple of corner cases in the MOVE/FETCH syntax.
Pavel Stehule
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index f430bcfad0f..65d508c37ed 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.142 2009/06/18 10:22:08 petere Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.143 2009/09/29 20:05:29 tgl Exp $ --> <chapter id="plpgsql"> <title><application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language</title> @@ -2655,16 +2655,18 @@ MOVE <optional> <replaceable>direction</replaceable> { FROM | IN } </optional> < </para> <para> - The options for the <replaceable>direction</replaceable> clause are - the same as for <command>FETCH</>, namely + The <replaceable>direction</replaceable> clause can be any of the + variants allowed in the SQL <xref linkend="sql-fetch" + endterm="sql-fetch-title"> command, namely <literal>NEXT</>, <literal>PRIOR</>, <literal>FIRST</>, <literal>LAST</>, <literal>ABSOLUTE</> <replaceable>count</replaceable>, <literal>RELATIVE</> <replaceable>count</replaceable>, - <literal>FORWARD</>, or - <literal>BACKWARD</>. + <literal>ALL</>, + <literal>FORWARD</> <optional> <replaceable>count</replaceable> | <literal>ALL</> </optional>, or + <literal>BACKWARD</> <optional> <replaceable>count</replaceable> | <literal>ALL</> </optional>. Omitting <replaceable>direction</replaceable> is the same as specifying <literal>NEXT</>. <replaceable>direction</replaceable> values that require moving @@ -2678,6 +2680,7 @@ MOVE <optional> <replaceable>direction</replaceable> { FROM | IN } </optional> < MOVE curs1; MOVE LAST FROM curs3; MOVE RELATIVE -2 FROM curs4; +MOVE FORWARD 2 FROM curs4; </programlisting> </para> </sect3> |