GNU/Linux |
RedHat 5.2(Apollo) |
|
![]() |
move(l) |
![]() |
move - move cursor position
move [ (forward | backward) ] [ ( number | all) ] [in cursor_name]
Move allows a user to move cursor position for specified number of instances. Move works like fetch command: it fetches instances, but put them nowhere.
--
--set up and use a cursor
--
begin work;
declare mycursor cursor for
select * from pg-user;
--
--Move for 5 instances in the cursor FOO
--
move 5 in FOO;
--
--Fetch 6th instance in the cursor FOO
--
fetch 1 in FOO;
--
--close
--
close foo;
commit;
begin(l), commit(l), close(l), fetch(l), select(l).
![]() |
move(l) | ![]() |