MOVE(7)                          SQL Commands                          MOVE(7)

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

SQL - Language Statements         2003-11-02                           MOVE(7)