Jeff Eckermann wrote:
>--- Ian Barwick <barwick@gmx.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
