"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
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
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 function would look
through (all) query results, then rewind the cursor and
