move \(em move cursor position

.nf

\fBmove\fR [ (\fBforward\fR | \fBbackward\fR) ] [ ( number | \fBall\fR) ] [\fBin\fR cursor_name]

.fi

.BR Move

allows a user to move cursor position for specified number of instances.

Move works like

.IR fetch

command: it fetches instances, but put them nowhere.

.nf

--

--set up and use a cursor

--

begin

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;

end;

.fi

begin(l),

end(l),

close(l),

fetch(l),

select(l).