DECLARING THE CURSOR WITH HOLD

From: Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com>
To: "pgus-general(at)postgresql(dot)org" <pgus-general(at)postgresql(dot)org>
Subject: DECLARING THE CURSOR WITH HOLD
Date: 2013-05-21 23:27:30
Message-ID: CDC1527B.41A53%sajeev_mayandi@symantec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgus-general

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.

Thanks,

Sajeev

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2013-05-22 00:21:54 Re: [GENERAL] ODBC constructs
Previous Message Sergey Konoplev 2013-05-21 23:26:38 Re: Strange locking problem

Browse pgus-general by date

  From Date Subject
Next Message Adrian Klaver 2013-05-22 00:57:03 Re: DECLARING THE CURSOR WITH HOLD
Previous Message Sandy Joseph Padala 2013-05-08 10:37:35 About Instant PostgreSQL Starter book from Packt