DECLARING THE CURSOR WITH HOLD

From: Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: DECLARING THE CURSOR WITH HOLD
Date: 2013-05-22 17:14:44
Message-ID: CDC24C66.41DD9%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 and postgresql version is 9.2.

Thanks,

Sajeev

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-05-22 17:19:07 Re: DECLARING THE CURSOR WITH HOLD
Previous Message Alvaro Herrera 2013-05-22 16:58:13 Re: VACUUM FULL freezes

Browse pgus-general by date

  From Date Subject
Next Message Pavel Stehule 2013-05-22 17:19:07 Re: DECLARING THE CURSOR WITH HOLD
Previous Message Adrian Klaver 2013-05-22 00:57:03 Re: DECLARING THE CURSOR WITH HOLD