diff options
Diffstat (limited to 'src/man/fetch.l')
-rw-r--r-- | src/man/fetch.l | 66 |
1 files changed, 0 insertions, 66 deletions
diff --git a/src/man/fetch.l b/src/man/fetch.l deleted file mode 100644 index 36cdc8d0c00..00000000000 --- a/src/man/fetch.l +++ /dev/null @@ -1,66 +0,0 @@ -.\" This is -*-nroff-*- -.\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/fetch.l,v 1.7 1998/06/24 13:21:26 momjian Exp $ -.TH FETCH SQL 01/23/93 PostgreSQL PostgreSQL -.SH NAME -fetch - fetch instance(s) from a cursor -.SH SYNOPSIS -.nf -\fBfetch\fR [ (\fBforward\fR | \fBbackward\fR) ] [ ( number | \fBall\fR) ] [\fBin\fR cursor_name] -.fi -.SH DESCRIPTION -.BR Fetch -allows a user to retrieve instances from a cursor named -.IR cursor_name. -The number of instances retrieved is specified by -.IR number . -If the number of instances remaining in the cursor is less than -.IR number , -then only those available are fetched. Substituting the keyword -.IR all -in place of a number will cause all remaining instances in the cursor -to be retrieved. Instances may be fetched in both -.IR forward -and -.IR backward -directions. The default direction is -.IR forward . -.PP -Updating data in a cursor is not supported by Postgres, because mapping -cursor updates back to base classes is impossible in general as with -view updates. Consequently, users must issue explicit replace -commands to update data. -.PP -Cursors may only be used inside of transaction blocks marked by -.IR begin(l) -and -.IR commit(l) -because the data that they store spans multiple user queries. -.SH EXAMPLE -.nf --- ---set up and use a cursor --- -begin work; -declare mycursor cursor for - select * from pg-user; --- ---Fetch all the instances available in the cursor FOO --- -fetch all in FOO; --- ---Fetch 5 instances backward in the cursor FOO --- -fetch backward 5 in FOO; --- ---close --- -close foo; -commit; -.fi -.SH "SEE ALSO" -begin(l), -commit(l), -close(l), -move(l), -select(l). |