GNU/Linux man pages
Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :
GNU/Linux |
RedHat 6.2(Zoot) |
|
 |
move(l) |
 |
MOVE − Moves cursor position
MOVE [
selector ] [ count ]
{ IN | FROM } cursor
FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ]
FROM ] cursor
MOVE allows a user to move cursor position a specified number of rows. MOVE works like the FETCH command, but only positions the cursor and does not return rows.
Refer to fetch(l) for details on syntax and usage.
NOTES
MOVE is a Postgres language extension.
Refer to fetch(l) for a description of valid arguments. Refer to declare(l) to define a cursor. Refer to begin(l), commit(l), and rollback(l) for further information about transactions.
Set up and use a cursor:
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;
--Skip first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE
--Fetch 6th row in the cursor liahona:
FETCH 1 IN liahona;
FETCH
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 commit work:
CLOSE liahona;
COMMIT WORK;
SQL92
There is no SQL92 MOVE statement. Instead, SQL92
allows one to FETCH rows from an absolute cursor
position, implicitly moving the cursor to the correct
position.
|
move(l) | |