Re: DECLARING THE CURSOR WITH HOLD

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(dot)klaver(at)gmail(dot)com