El día 29 de agosto de 2011 15:28, Pavel Stehule
<pavel.stehule@gmail.com> escribió:
> 2011/8/29 Martín Marqués <martin.marques@gmail.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.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador