2011/8/29 Martín Marqués <martin.marques@xxxxxxxxx>:
> El día 29 de agosto de 2011 15:52, Pavel Stehule
> <pavel.stehule@xxxxxxxxx> escribió:
>> 2011/8/29 Martín Marqués <martin.marques@xxxxxxxxx>:
>>> El día 29 de agosto de 2011 15:28, Pavel Stehule
>>> <pavel.stehule@xxxxxxxxx> escribió:
>>>> 2011/8/29 Martín Marqués <martin.marques@xxxxxxxxx>:
>>>>> 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.
>
DECLARE
curs1 refcursor;
BEGIN
OPEN curs1 FOR EXECUTE 'SELECT ...';
>
> --
> Martín Marqués
> select 'martin.marques' || '@' || 'gmail.com'
> DBA, Programador, Administrador
>
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
