DECLARING THE CURSOR WITH HOLD

[Sajeev Mayandi <Sajeev_Mayandi@xxxxxxxxxxxx>]

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