MOVE

Move ::= MOVE [ direction [ FROM | IN ] ] cursor_name;

direction ::= NEXT
   | PRIOR
   | FIRST
   | LAST
   | ABSOLUTE count
   | RELATIVE count
   | count
   | ALL
   | FORWARD
   | FORWARD count
   | FORWARD ALL
   | BACKWARD
   | BACKWARD count
   | BACKWARD ALL

-- Start a transaction.
mogdb=# START TRANSACTION;

-- Define a cursor cursor1.
mogdb=# CURSOR cursor1 FOR SELECT * FROM tpcds.reason;

-- Skip the first three rows of cursor1.
mogdb=# MOVE FORWARD 3 FROM cursor1;

-- Fetch the first four rows from cursor1.
mogdb=# FETCH 4 FROM cursor1;
 r_reason_sk |   r_reason_id    |                                            r_reason_desc
-------------+------------------+------------------------------------------------------------------------------------------------------
           4 | AAAAAAAAEAAAAAAA | Not the product that was ordred
           5 | AAAAAAAAFAAAAAAA | Parts missing
           6 | AAAAAAAAGAAAAAAA | Does not work with a product that I have
           7 | AAAAAAAAHAAAAAAA | Gift exchange
(4 rows)

-- Close the cursor.
mogdb=# CLOSE cursor1;

-- End the transaction.
mogdb=# END;