MOVE SQL - Language Statements MOVE Moves cursor position 1999-07-20 MOVE [ selector ] [ count ] { IN | FROM } cursor FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ] FROM ] cursor 1998-09-24 MOVE allows a user to move cursor position a specified number of rows. MOVE works like the FETCH command, but only positions the cursor and does not return rows. Refer to for details on syntax and usage. 1998-09-24 MOVE is a Postgres language extension. Refer to for a description of valid arguments. Refer to to define a cursor. Refer to , , and for further information about transactions. Set up and use a cursor: BEGIN WORK; DECLARE liahona CURSOR FOR SELECT * FROM films; --Skip first 5 rows: MOVE FORWARD 5 IN liahona; MOVE --Fetch 6th row in the cursor liahona: FETCH 1 IN liahona; FETCH 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 commit work: CLOSE liahona; COMMIT WORK; 1998-09-01 There is no SQL92 MOVE statement. Instead, SQL92 allows one to FETCH rows from an absolute cursor position, implicitly moving the cursor to the correct position.