Thread: FETCH help

Hi,
 The FETCH help seems to be odd in PostgreSQL-7.0.

prompt> psql
postgres=# \h fetch
Command:     FETCH
Description: Gets rows using a cursor
Syntax:
FETCH [ selector ] [ count ] { IN | FROM } cursor
FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ] FROM ] cursor
~~~~~~~
 Probably the next syntax would be correct, right ?
-----
Syntax:
FETCH [ FORWARD | BACKWARD | RELATIVE ]     [ { [ # | ALL | NEXT | PRIOR ] } ] { IN | FROM } cursor
FETCH cursor
-----

--
Regards,
SAKAIDA Masaaki  -- Osaka, Japan

> Hi,
> 
>   The FETCH help seems to be odd in PostgreSQL-7.0.
> 
> prompt> psql
> postgres=# \h fetch
> Command:     FETCH
> Description: Gets rows using a cursor
> Syntax:
> FETCH [ selector ] [ count ] { IN | FROM } cursor
> FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ] FROM ] cursor

Yes, it was a mess.  New display looks like below.  SGML fixed too.  It
now displays in brief and long formats.

---------------------------------------------------------------------------

test=> \h fetch
Command:     FETCH
Description: Gets rows using a cursor
Syntax:
FETCH [ direction ] [ count ] { IN | FROM } cursor
FETCH [ FORWARD | BACKWARD | RELATIVE ] [ # | ALL | NEXT | PRIOR ] { IN | FROM }cursor



--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026