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
