MOVE SQL - Language Statements MOVE position a cursor on a specified row of a table 1999-07-20 MOVE [ direction ] {count | LAST } { IN | FROM } cursor 1998-09-24 MOVE allows a user to move the cursor position a specified number of rows. MOVE works like the FETCH command, but only positions the cursor and does not return rows. LAST moves to the end of the cursor. Refer to for details on syntax and usage. 1998-09-24 MOVE is a PostgreSQL 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.