MOVE
MOVE —定位光标
Synopsis
MOVE [ direction [ FROM | IN ] ] cursor_name
where direction can be empty or one of:
NEXT
PRIOR
FIRST
LAST
ABSOLUTE count
RELATIVE count
count
ALL
FORWARD
FORWARD count
FORWARD ALL
BACKWARD
BACKWARD count
BACKWARD ALL
Description
MOVE重新定位光标而未获取任何数据。 MOVE的工作方式与FETCH命令完全相同，只不过它仅定位光标而不返回行。
MOVE命令的参数与FETCH命令的参数相同。有关语法和用法的详细信息，请参阅FETCH。
Outputs
成功完成后，MOVE命令将返回以下形式的命令标签：
MOVE count
count*是具有相同参数的FETCH命令返回的行数(可能为零)。
Examples
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;
Compatibility
SQL 标准中没有MOVE语句。