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
