| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | SAKAIDA Masaaki <sakaida(at)psn(dot)co(dot)jp> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: FETCH help |
| Date: | 2000-05-11 17:50:38 |
| Message-ID: | 200005111750.NAA19704@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-05-11 17:54:41 | Re: Orphaned locks in 7.0? |
| Previous Message | Bruce Momjian | 2000-05-11 17:47:31 | Re: User's Lounge and Developer's Corner |