From: | Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(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:21:37 |
Message-ID: | CDC24E13.41E25%sajeev_mayandi@symantec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgus-general |
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 | Pavel Stehule | 2013-05-22 17:23:45 | Re: DECLARING THE CURSOR WITH HOLD |
Previous Message | Pavel Stehule | 2013-05-22 17:19:07 | Re: DECLARING THE CURSOR WITH HOLD |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-05-22 17:23:45 | Re: DECLARING THE CURSOR WITH HOLD |
Previous Message | Pavel Stehule | 2013-05-22 17:19:07 | Re: DECLARING THE CURSOR WITH HOLD |