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