MOVE

NAME
SYNOPSIS
DESCRIPTION æè¿°
OUTPUTS è¾åº
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
è¯è
è·

---

NAME

MOVE - éå®ä½ä¸ä¸ªæ¸¸æ

SYNOPSIS

MOVE [ direction { FROM | IN } ] cursorname

DESCRIPTION æè¿°

MOVE å¨ä¸æ£ç´¢æ°æ®çæåµä¸éæ°å®ä½ä¸ä¸ªæ¸¸æ ã MOVE ALL æ游æ ç§»å¨å°ç»å°¾ã MOVE çå·¥ä½ç±»ä¼¼äº FETCH å½ä»¤ï¼ ä½åªæ¯éå®ä½æ¸¸æ èä¸è¿åè¡ã

请åè FETCH [fetch(7)] å½ä»¤è·åè¯æ³ååæ°ç详ç»ä¿¡æ¯ã

OUTPUTS è¾åº

æåå®ææ¶ï¼MOVE å½ä»¤è¿åä¸ä¸ªä¸é¢å½¢å¼çå½ä»¤æ ç¾

MOVE count

count æ¯ç§»å¨çè¡æ°ï¼å¯è½ä¸ºé¶ï¼ã

EXAMPLES ä¾å

设置å使ç¨ä¸ä¸ªæ¸¸æ ï¼

BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;

-- 忽ç¥å¼å¤´ 5 è¡ï¼
MOVE FORWARD 5 IN liahona;
MOVE 5

-- æåæ¸¸æ  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)

-- å³éæ¸¸æ  liahona 并æ交工ä½ï¼
CLOSE liahona;
COMMIT WORK;

COMPATIBILITY å¼å®¹æ§

SQL æ åé没æ MOVE è¯å¥ã

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---