Re: [SQL] [GENERAL] Scrolling cursors in PL/PgSQL

2007-11-01 Thread Tom Lane
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes: > Is there a way to scroll a cursor from within PL/PgSQL? FWIW, in 8.3 plpgsql has full FETCH/MOVE support --- that might or might not help you, depending on what your timescale for deploying this application is ... regards, tom

Re: [SQL] [GENERAL] Scrolling cursors in PL/PgSQL

2007-11-01 Thread Pavel Stehule
On 01/11/2007, Dawid Kuroczko <[EMAIL PROTECTED]> wrote: > Hello. > > Is there a way to scroll a cursor from within PL/PgSQL? > > I tried EXECUTE, but: > > ERROR: cannot manipulate cursors directly in PL/pgSQL > HINT: Use PL/pgSQL's cursor features instead. > > The idea would be that PL/pgsql fun