Re: [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: [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

Re: [GENERAL] Scrolling cursors in PL/PgSQL

2007-11-01 Thread Raymond O'Donnell
On 01/11/2007 20:19, Dawid Kuroczko wrote: > Any other idea how to efficiently solve such a problem? How about creating a temporary table within your function and using that instead? Ray. --- Raymond O'Donnell, Director of Music, G