MOVE — position a cursor
direction[ FROM | IN ] ]
directioncan be empty or one of: NEXT PRIOR FIRST LAST ABSOLUTE
countALL FORWARD FORWARD
countFORWARD ALL BACKWARD BACKWARD
MOVE repositions a cursor
without retrieving any data.
works exactly like the
command, except it only positions the cursor and does not
The parameters for the
command are identical to those of the
FETCH command; refer to FETCH for details on syntax and
On successful completion, a
MOVE command returns a command tag of the
count is the
number of rows that a
command with the same parameters would have returned (possibly
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;
There is no
MOVE statement in
the SQL standard.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.