From: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: passing cursors from one PL function to another |
Date: | 2011-08-29 19:02:51 |
Message-ID: | CABeG9LtvYhnsVSXf196yzhkOOeovTTiq9Q6YtDSus7dWw_x=Xw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
El día 29 de agosto de 2011 15:52, Pavel Stehule
<pavel(dot)stehule(at)gmail(dot)com> escribió:
> 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
OK, I'm totally lost. How do you define a dynamic cursor? Couldn't
find anything in the manuals.
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-08-29 19:12:35 | Re: passing cursors from one PL function to another |
Previous Message | Pavel Stehule | 2011-08-29 18:52:54 | Re: passing cursors from one PL function to another |