Re: Fun with Cursors- how to rewind a cursor

"Postgres User" <postgres.developer@xxxxxxxxx> · Thu, 1 Mar 2007 22:04:05 -0800

I had tried several variations of MOVE Backward inside an Execute
statement earlier.  And now, I'm seeing this error appear again:

ERROR: 0A000: cannot manipulate cursors directly in PL/pgSQL

I updated the Postgres function below with this replacement line:
Execute 'MOVE Backward All In c_entry';

Any other thoughts?

On 3/1/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Postgres User" <postgres.developer@xxxxxxxxx> writes:
> So I added the following code:

> <before opening cursor>     ref_entry = 'c_entry';
> <after looping thru cursor>  MOVE Backward All In c_entry;

You have to use EXECUTE for the latter.

                       regards, tom lane