Missing Docs for MOVE direction?

Started by David E. Wheelerover 16 years ago3 messages
#1David E. Wheeler
david@kineticode.com

Howdy,

I was just looking at the documentation for cursors command, and
noticed that the MOVE command's "direction" argument doesn't seem to
have documentation for its possible values.

http://www.postgresql.org/docs/8.4/static/sql-move.html

I assume that they should be FORWARD and BACKWARD, as the former is
used in the example, but in truth I have no idea.

Also, what's the difference between the FROM and IN clauses? Or are
they they same thing?

Thanks,

David

#2David E. Wheeler
david@kineticode.com
In reply to: David E. Wheeler (#1)
Re: Missing Docs for MOVE direction?

On Jun 21, 2009, at 5:07 PM, David E. Wheeler wrote:

I was just looking at the documentation for cursors command, and
noticed that the MOVE command's "direction" argument doesn't seem to
have documentation for its possible values.

http://www.postgresql.org/docs/8.4/static/sql-move.html

I assume that they should be FORWARD and BACKWARD, as the former is
used in the example, but in truth I have no idea.

Also, what's the difference between the FROM and IN clauses? Or are
they they same thing?

Bah! I now see that these expressions are the same as for FETCH.
Something like this would help, I think:

*** move.sgml.~1.31.~	Thu Nov 20 20:39:34 2008
--- move.sgml	Sun Jun 21 17:15:44 2009
***************
*** 40,46 ****
     </para>
     <para>
!    Refer to
      <xref linkend="sql-fetch" endterm="sql-fetch-title">
      for details on syntax and usage.
     </para>
--- 40,47 ----
     </para>

<para>
! The parameters for <command>MOVE</command> are identical to those
for
! <command>FETCH</command>; refer to
<xref linkend="sql-fetch" endterm="sql-fetch-title">
for details on syntax and usage.
</para>

Thanks,

David

#3Peter Eisentraut
peter_e@gmx.net
In reply to: David E. Wheeler (#2)
Re: Missing Docs for MOVE direction?

On Monday 22 June 2009 03:15:57 David E. Wheeler wrote:

On Jun 21, 2009, at 5:07 PM, David E. Wheeler wrote:

I was just looking at the documentation for cursors command, and
noticed that the MOVE command's "direction" argument doesn't seem to
have documentation for its possible values.

http://www.postgresql.org/docs/8.4/static/sql-move.html

I assume that they should be FORWARD and BACKWARD, as the former is
used in the example, but in truth I have no idea.

Also, what's the difference between the FROM and IN clauses? Or are
they they same thing?

Bah! I now see that these expressions are the same as for FETCH.
Something like this would help, I think:

*** move.sgml.~1.31.~	Thu Nov 20 20:39:34 2008
--- move.sgml	Sun Jun 21 17:15:44 2009
***************
*** 40,46 ****
</para>
<para>
!    Refer to
<xref linkend="sql-fetch" endterm="sql-fetch-title">
for details on syntax and usage.
</para>
--- 40,47 ----
</para>

<para>
! The parameters for <command>MOVE</command> are identical to those
for
! <command>FETCH</command>; refer to
<xref linkend="sql-fetch" endterm="sql-fetch-title">
for details on syntax and usage.
</para>

Thanks,

David

done