|
| 1 | +.\" This is -*-nroff-*- |
| 2 | +.\" XXX standard disclaimer belongs here.... |
| 3 | +.\" $Header: /cvsroot/pgsql/src/man/Attic/move.l,v 1.1 1997/10/02 03:15:11 vadim Exp $ |
| 4 | +.TH MOVE SQL 01/23/93 PostgreSQL PostgreSQL |
| 5 | +.SH NAME |
| 6 | +move\(em move cursor position |
| 7 | +.SH SYNOPSIS |
| 8 | +.nf |
| 9 | +\fBmove\fR [ (\fBforward\fR |\fBbackward\fR) ] [ ( number |\fBall\fR) ] [\fBin\fR cursor_name] |
| 10 | +.fi |
| 11 | +.SH DESCRIPTION |
| 12 | +.BR Move |
| 13 | +allows a user to move cursor position for specified number of instances. |
| 14 | +Move works like |
| 15 | +.IR fetch |
| 16 | +command: it fetches instances, but put them nowhere. |
| 17 | +.SH EXAMPLE |
| 18 | +.nf |
| 19 | +-- |
| 20 | +--set up and use a cursor |
| 21 | +-- |
| 22 | +begin |
| 23 | + declare mycursor cursor for |
| 24 | + select * from pg-user; |
| 25 | +-- |
| 26 | +--Move for 5 instances in the cursor FOO |
| 27 | +-- |
| 28 | + move 5 in FOO; |
| 29 | +-- |
| 30 | +--Fetch 6th instance in the cursor FOO |
| 31 | +-- |
| 32 | + fetch 1 in FOO; |
| 33 | +-- |
| 34 | +--close |
| 35 | +-- |
| 36 | + close foo; |
| 37 | +end; |
| 38 | +.fi |
| 39 | +.SH "SEE ALSO" |
| 40 | +begin(l), |
| 41 | +end(l), |
| 42 | +close(l), |
| 43 | +fetch(l), |
| 44 | +select(l). |