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 <[EMAIL PROTECTED]> wrote:
"Postgres User" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
