Maybe refcursors ?? All what you can do with cursors is described in http://www.postgresql.org/docs/9.3/static/plpgsql-cursors.html Regards Pavel 2013/5/22 Sajeev Mayandi <Sajeev_Mayandi@xxxxxxxxxxxx>: > Is there a work around to declare the cursor with hold? > > Thanks, > > Sajeev > > On 5/22/13 10:19 AM, "Pavel Stehule" <pavel.stehule@xxxxxxxxx> wrote: > >>Hello >> >>2013/5/22 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. >>> >> >>holdable cursors are not supported in plpgsql >> >>Regards >> >>Pavel Stehule >> >>> Thanks, >>> >>> Sajeev > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
