Thread: Missing Docs for MOVE direction?

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

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
syntaxand usage.    </para>
 

Thanks,

David

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