diff options
Diffstat (limited to 'doc/src/sgml/ref/move.sgml')
| -rw-r--r-- | doc/src/sgml/ref/move.sgml | 252 |
1 files changed, 133 insertions, 119 deletions
diff --git a/doc/src/sgml/ref/move.sgml b/doc/src/sgml/ref/move.sgml index 50dd279062..fdac32aca4 100644 --- a/doc/src/sgml/ref/move.sgml +++ b/doc/src/sgml/ref/move.sgml @@ -1,124 +1,138 @@ -<REFENTRY ID="SQL-MOVE"> -<REFMETA> -<REFENTRYTITLE> -MOVE -</REFENTRYTITLE> -<REFMISCINFO>SQL - Language Statements</REFMISCINFO> -</REFMETA> -<REFNAMEDIV> -<REFNAME> -MOVE -</REFNAME> -<REFPURPOSE> -Moves cursor position -</REFPURPOSE> - </refnamediv> -<REFSYNOPSISDIV> -<REFSYNOPSISDIVINFO> -<DATE>1998-09-24</DATE> -</REFSYNOPSISDIVINFO> -<SYNOPSIS> -MOVE [ <REPLACEABLE CLASS="PARAMETER">selector</REPLACEABLE> ] [ <REPLACEABLE CLASS="PARAMETER">count</REPLACEABLE> ] - { IN | FROM } <REPLACEABLE CLASS="PARAMETER">cursor</REPLACEABLE> -FETCH [ RELATIVE ] [ { [ <REPLACEABLE CLASS="PARAMETER">#</REPLACEABLE> | ALL | NEXT | PRIOR ] } ] FROM ] <REPLACEABLE CLASS="PARAMETER">cursor</REPLACEABLE> - </SYNOPSIS> - </refsynopsisdiv> +<refentry id="SQL-MOVE"> + <refmeta> + <refentrytitle> + MOVE + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> + MOVE + </refname> + <refpurpose> + Moves cursor position + </refpurpose> + </refnamediv> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-24</date> + </refsynopsisdivinfo> + <synopsis> +MOVE [ <replaceable class="PARAMETER">selector</replaceable> ] [ <replaceable class="PARAMETER">count</replaceable> ] + { IN | FROM } <replaceable class="PARAMETER">cursor</replaceable> + FETCH [ RELATIVE ] [ { [ <replaceable class="PARAMETER">#</replaceable> | ALL | NEXT | PRIOR ] } ] FROM ] <replaceable class="PARAMETER">cursor</replaceable> + </synopsis> + </refsynopsisdiv> + + <refsect1 id="R1-SQL-MOVE-1"> + <refsect1info> + <date>1998-09-24</date> + </refsect1info> + <title> + Description + </title> + <para> + <command>MOVE</command> allows a user to move cursor position a specified + number of rows. + <command>MOVE</command> works like the <command>FETCH</command> command, + but only positions the cursor and does + not return rows. + </para> + <para> + Refer to the <command>FETCH</command> command for details on syntax and usage. + </para> - <REFSECT1 ID="R1-SQL-MOVE-1"> - <REFSECT1INFO> - <DATE>1998-09-24</DATE> - </REFSECT1INFO> - <TITLE> - Description - </TITLE> - <PARA> - <command>MOVE</command> allows a user to move cursor position a specified - number of rows. - <command>MOVE</command> works like the <command>FETCH</command> command, - but only positions the cursor and does - not return rows. - </para> - <para> - Refer to the <command>FETCH</command> command for details on syntax and usage. - </para> + <refsect2 id="R2-SQL-MOVE-3"> + <refsect2info> + <date>1998-09-24</date> + </refsect2info> + <title> + Notes + </title> + <para> + <command>MOVE</command> is a <productname>Postgres</productname> + language extension. + </para> + <para> + Refer to <command>FETCH</command> for a description + of valid arguments. + Refer to <command>DECLARE</command> to declare a cursor. + Refer to <command>BEGIN WORK</command>, <command>COMMIT WORK</command>, + <command>ROLLBACK WORK</command> statements + for further information about transactions. + </para> + </refsect2> + </refsect1> - <REFSECT2 ID="R2-SQL-MOVE-3"> - <REFSECT2INFO> - <DATE>1998-09-24</DATE> - </REFSECT2INFO> - <TITLE> - Notes - </TITLE> - <PARA> - <command>MOVE</command> is a <productname>Postgres</productname> - language extension. - </para> - <para> - Refer to <command>FETCH</command> for a description - of valid arguments. - Refer to <command>DECLARE</command> to declare a cursor. - Refer to <command>BEGIN WORK</command>, <command>COMMIT WORK</command>, - <command>ROLLBACK WORK</command> statements - for further information about transactions. - </para> - </REFSECT2> - </refsect1> + <refsect1 id="R1-SQL-MOVE-2"> + <title> + Usage + </title> + <para> + Set up and use a cursor: - <REFSECT1 ID="R1-SQL-MOVE-2"> - <TITLE> - Usage - </TITLE> - <PARA> - <ProgramListing> - --set up and use a cursor: - -- - BEGIN WORK; - DECLARE liahona CURSOR FOR SELECT * FROM films; - - --Skip first 5 rows: - -- - MOVE FORWARD 5 IN liahona; - <computeroutput> - MOVE - </computeroutput> - --Fetch 6th row in the cursor liahona: - -- - FETCH 1 IN liahona; - <computeroutput> - FETCH - code |title |did| date_prod|kind |len - -----+------+---+----------+----------+------ - P_303|48 Hrs|103|1982-10-22|Action | 01:37 - (1 row) - </computeroutput> - -- close the cursor liahona and commit work: - -- - CLOSE liahona; - COMMIT WORK; - </ProgramListing> - </para> - </REFSECT1> + <programlisting> +BEGIN WORK; +DECLARE liahona CURSOR FOR SELECT * FROM films; +--Skip first 5 rows: +MOVE FORWARD 5 IN liahona; +<computeroutput> +MOVE +</computeroutput> +--Fetch 6th row in the cursor liahona: +FETCH 1 IN liahona; +<computeroutput> +FETCH + + code |title |did| date_prod|kind |len + -----+------+---+----------+----------+------ + P_303|48 Hrs|103|1982-10-22|Action | 01:37 + (1 row) +</computeroutput> +-- close the cursor liahona and commit work: +CLOSE liahona; +COMMIT WORK; + </programlisting> + </para> + </refsect1> - <REFSECT1 ID="R1-SQL-MOVE-3"> - <TITLE> - Compatibility - </TITLE> - <PARA> - </PARA> + <refsect1 id="R1-SQL-MOVE-3"> + <title> + Compatibility + </title> + <para> + </para> - <REFSECT2 ID="R2-SQL-MOVE-4"> - <REFSECT2INFO> - <DATE>1998-09-01</DATE> - </REFSECT2INFO> - <TITLE> - SQL92 - </TITLE> - <PARA> - There is no SQL92 <command>MOVE</command> statement. - Instead, <acronym>SQL92</acronym> allows - one to <command>FETCH</command> rows from an absolute cursor position, - implicitly moving the cursor to the correct place. - </para> - </refsect2> - </refsect1> -</REFENTRY> + <refsect2 id="R2-SQL-MOVE-4"> + <refsect2info> + <date>1998-09-01</date> + </refsect2info> + <title> + SQL92 + </title> + <para> + There is no SQL92 <command>MOVE</command> statement. + Instead, <acronym>SQL92</acronym> allows + one to <command>FETCH</command> rows from an absolute cursor position, + implicitly moving the cursor to the correct place. + </para> + </refsect2> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> |