| 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:42:17 |
| Message-ID: | CABeG9Lvc4r9srsuS=v=qCif4C5nLZGWWebWqvx39weujKLvGow@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El día 29 de agosto de 2011 16:12, Pavel Stehule
<pavel(dot)stehule(at)gmail(dot)com> escribió:
> 2011/8/29 Martín Marqués <martin(dot)marques(at)gmail(dot)com>:
>>>
>>> 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 ...';
OK, not that easy, but I think I got it working.
Thanks alot Pavel!
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2011-08-29 20:29:44 | Re: dropdb: database removal failed: active sessions |
| Previous Message | JD Wong | 2011-08-29 19:22:43 | dropdb: database removal failed: active sessions |