FETCH help

Started by SAKAIDA Masaakiover 25 years ago2 messages
#1SAKAIDA Masaaki
sakaida@psn.co.jp

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

#2Bruce Momjian
pgman@candle.pha.pa.us
In reply to: SAKAIDA Masaaki (#1)
Re: 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