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



Thu, 11 May 2000 15:53:58 +0900
SAKAIDA Masaaki <sakaida@psn.co.jp>
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

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, Pennsylvania 19026

Thu, 11 May 2000 13:50:38 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: FETCH help