From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DECLARING THE CURSOR WITH HOLD |
Date: | 2013-05-22 17:23:45 |
Message-ID: | CAFj8pRAKcVLOTHKUtfuKQ6WSSoqt2vS1odjwjp1g7NG396Hreg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgus-general |
Maybe refcursors ??
All what you can do with cursors is described in
http://www.postgresql.org/docs/9.3/static/plpgsql-cursors.html
Regards
Pavel
2013/5/22 Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com>:
> Is there a work around to declare the cursor with hold?
>
> Thanks,
>
> Sajeev
>
> On 5/22/13 10:19 AM, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
>>Hello
>>
>>2013/5/22 Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com>:
>>>
>>>
>>> Hi,
>>>
>>> I am trying to declare a cursor with hold along with NO SCROLL option.
>>> I
>>> am getting syntax error. Just wondering if CURSOR WITH HOLD option
>>> supported. My code snip is.
>>>
>>> DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from
>>> phostmapping;
>>>
>>> NOTE: The code is in plpgsql and postgresql version is 9.2.
>>>
>>
>>holdable cursors are not supported in plpgsql
>>
>>Regards
>>
>>Pavel Stehule
>>
>>> Thanks,
>>>
>>> Sajeev
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-05-22 17:36:09 | Re: Ambiguous order by? |
Previous Message | Sajeev Mayandi | 2013-05-22 17:21:37 | Re: DECLARING THE CURSOR WITH HOLD |
From | Date | Subject | |
---|---|---|---|
Next Message | Jesus Rafael Sanchez Medrano | 2013-11-26 18:14:34 | Any advantage of using SSL with a certificate of authority? |
Previous Message | Sajeev Mayandi | 2013-05-22 17:21:37 | Re: DECLARING THE CURSOR WITH HOLD |