<[EMAIL PROTECTED]> writes:
> I declare a cursor as below:
> DECLARE
> links_cur SCROLL CURSOR IS SELECT * FROM road;
> and get this error:
> CONTEXT: invalid type name "SCROLL CURSOR IS SELECT * FROM road"
What PG version? IIRC plpgsql didn't allow the SCROLL modifier there
It seems to me that scroll cursors are not valid in plpgsql.
The following query in PGAdmin works. run one line at a time.
begin work;
declare bob scroll cursor for select * from testtbl;
fetch forward 5 from bob;
fetch prior from bob;
rollback work;
"Larry Morroni" <[EMAIL PROTECTED]> wrote
