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
示例
BEGIN WORK; DECLARE liahona CURSOR FOR SELECT * FROM films; -- 跳过前 5 行: MOVE FORWARD 5 IN liahona; MOVE 5 -- 从游标 liahona 中取第 6 行: FETCH 1 FROM liahona; code | title | did | date_prod | kind | len -------+--------+-----+------------+--------+------- P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37 (1 row) -- 关闭游标 liahona 并且结束事务: CLOSE liahona; COMMIT WORK;