Re: passing cursors from one PL function to another

2011/8/29 Martín Marqués <martin(dot)marques(at)gmail(dot)com>:
> El día 29 de agosto de 2011 15:28, Pavel Stehule
> <pavel(dot)stehule(at)gmail(dot)com> escribió:
>> 2011/8/29 Martín Marqués <martin(dot)marques(at)gmail(dot)com>:
>>> Actually, what we are trying to do is return 2 recordsets with the
>>> same function call (simulate SP from SQL Server returning 2
>>> recordsets).
>>>
>>> I found out that I had to do PERFORM * FROM construyecursordesdequery($1, query)
>>> which works now, but can't run 2 different queries on the same cursor.
>>>
>>
>> in your example you use a static cursor.
>
> As opposed to? I see no way to define a cursor not-static.

refcursors can be dynamic defined

Pavel

>
> --
> Martín Marqués
> select 'martin.marques' || '@' || 'gmail.com'
> DBA, Programador, Administrador
>