<[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
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"
If I take away 'SCROLL', it has no problem.
Any hint?
Thanks,
cyw
--
Sent via pgsql-general mailing lis
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
