From: Sajeev Mayandi <Sajeev_Mayandi@symantec.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: DECLARING THE CURSOR WITH HOLD
Date: Wed, 22 May 2013 10:21:37 -0700
Message-ID: <CDC24E13.41E25%sajeev_mayandi@symantec.com> (raw)
In-Reply-To: <CAFj8pRD3kR=6HVJXRsVoJDw+5k8BAwLT7TSvXW0YTH7feW_xuA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Is there a work around to declare the cursor with hold?
Thanks,
Sajeev
On 5/22/13 10:19 AM, "Pavel Stehule" <pavel.stehule@gmail.com> wrote:
>Hello
>
>2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@symantec.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgus-general@postgresql.org
Cc: Sajeev_Mayandi@symantec.com, pavel.stehule@gmail.com, pgsql-general@postgresql.org
Subject: Re: DECLARING THE CURSOR WITH HOLD
In-Reply-To: <CDC24E13.41E25%sajeev_mayandi@symantec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox