Re: context in plpgsql functions

Jeff Eckermann wrote:

>--- Ian Barwick <barwick(at)gmx(dot)net> wrote:
>
>
>>On Friday 16 May 2003 20:46, Gianni Mariani wrote:
>>
>>
>>>I've been using PostgreSQL 7.3.2.
>>>
>>>What, if any, way is there to share a context
>>>
>>>
>>(global rowtype variable)
>>
>>
>>>between plpgsql functions ?
>>>
>>>
>>If you mean something like Oracle's PL/SQL packages,
>>which can
>>contain package global variables, then unfortunately
>>not.
>>
>>
>
>I believe the usual workaround is to insert the values
>in a table which has been created for that purpose.
>
>
Yes - I was thinking of that - I was also thinking you could use a
cursor to do the job of pointing to the record in the table you care about.

However, when I try to do a MOVE cursor inside a plpgsql function i get :

EXECUTE ''MOVE BACKWARD 1 IN "ContextCursor"''

psql:kkk4:145: ERROR: unexpected error -5 in EXECUTE of query 'MOVE
BACKWARD 1 IN "ContextCursor"'

or a

PERFORM MOVE BACKWARD 1 IN "ContextCursor";

psql:kkk4:145: ERROR: parser: parse error at or near "BACKWARD" at
character 14

or

MOVE BACKWARD 1 IN "ContextCursor";

psql:kkk4:145: ERROR: SPI_prepare() failed on "MOVE BACKWARD 1 IN
"ContextCursor""

.... yet that same statement works fine elsewhere ...

Ideas on how to move a cursor inside a plpgsql function ?

TIA