| 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:19:07 |
| Message-ID: | CAFj8pRD3kR=6HVJXRsVoJDw+5k8BAwLT7TSvXW0YTH7feW_xuA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgus-general |
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 | Sajeev Mayandi | 2013-05-22 17:21:37 | Re: DECLARING THE CURSOR WITH HOLD |
| Previous Message | Sajeev Mayandi | 2013-05-22 17:14:44 | DECLARING THE CURSOR WITH HOLD |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sajeev Mayandi | 2013-05-22 17:21:37 | Re: DECLARING THE CURSOR WITH HOLD |
| Previous Message | Sajeev Mayandi | 2013-05-22 17:14:44 | DECLARING THE CURSOR WITH HOLD |