agora inbox for pgus-general@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@gmail.com>
To: Sajeev Mayandi <Sajeev_Mayandi@symantec.com>
Cc: pgus-general@postgresql.org <pgus-general@postgresql.org>
Subject: Re: DECLARING THE CURSOR WITH HOLD
Date: Tue, 21 May 2013 17:57:03 -0700
Message-ID: <519C17DF.1050709@gmail.com> (raw)
In-Reply-To: <CDC1527B.41A53%sajeev_mayandi@symantec.com>
References: <CDC1527B.41A53%sajeev_mayandi@symantec.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgus-general>
On 05/21/2013 04:27 PM, Sajeev Mayandi wrote:
> 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.
Two things.
1) The correct list for questions like this is:
pgsql-general
You can subscribe here:
http://www.postgresql.org/community/lists/subscribe/
2) When you resubmit this post the following information would be helpful:
Postgres version
The actual error message
The DECLARE statement in context, in other words show as much of the
plpgsql code as possible.
>
> Thanks,
>
> Sajeev
--
Adrian Klaver
adrian.klaver@gmail.com
--
Sent via pgus-general mailing list (pgus-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgus-general
view thread (6+ messages) latest in thread
Message-ID: <519C17DF.1050709@gmail.com>
Permalink: ../519C17DF.1050709@gmail.com/
Also on: postgresql.org/message-id/519C17DF.1050709@gmail.com
reply
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: adrian.klaver@gmail.com, Sajeev_Mayandi@symantec.com
Subject: Re: DECLARING THE CURSOR WITH HOLD
In-Reply-To: <519C17DF.1050709@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox