move.7

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· 7 代码 · 共 60 行

.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
.TH "MOVE" "" "2008-01-03" "SQL - Language Statements" "SQL Commands"
.SH NAME
MOVE \- position a cursor

.SH SYNOPSIS
.sp
.nf
MOVE [ \fIdirection\fR { FROM | IN } ] \fIcursorname\fR
.sp
.fi
.SH "DESCRIPTION"
.PP
\fBMOVE\fR repositions a cursor without retrieving any data.
\fBMOVE\fR works exactly like the \fBFETCH\fR
command, except it only positions the cursor and does not return rows.
.PP
Refer to 
FETCH [\fBfetch\fR(7)]
for details on syntax and usage.
.SH "OUTPUTS"
.PP
On successful completion, a \fBMOVE\fR command returns a command
tag of the form
.sp
.nf
MOVE \fIcount\fR
.sp
.fi
The \fIcount\fR is the number
of rows that a \fBFETCH\fR command with the same parameters
would have returned (possibly zero).
.SH "EXAMPLES"
.sp
.nf
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;

-- Skip the first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE 5

-- Fetch the 6th row from the cursor liahona:
FETCH 1 FROM liahona;
 code  | title  | did | date_prod  |  kind  |  len
-------+--------+-----+------------+--------+-------
 P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
(1 row)

-- Close the cursor liahona and end the transaction:
CLOSE liahona;
COMMIT WORK;
.sp
.fi
.SH "COMPATIBILITY"
.PP
There is no \fBMOVE\fR statement in the SQL standard.
.SH "SEE ALSO"
CLOSE [\fBclose\fR(7)], DECLARE [\fBdeclare\fR(l)], FETCH [\fBfetch\fR(l)]