[GENERAL] DECLARING THE CURSOR WITH HOLD

[Sajeev Mayandi]

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