Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfCcu-00079V-Uo for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 17:15:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UfCcu-0006HU-Dg for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 17:15:00 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfCct-0006HO-0I for pgsql-general@postgresql.org; Wed, 22 May 2013 17:14:59 +0000 Received: from ecl1mtaoutpex02.symantec.com ([166.98.1.210]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UfCci-0000zf-7c for pgsql-general@postgresql.org; Wed, 22 May 2013 17:14:58 +0000 X-AuditID: a66201d2-b7f7f6d0000033f9-5d-519cfd06a55e Received: from ecl1mtahubpin02.ges.symantec.com (ecl1mtahubpin02.ges.symantec.com [10.48.69.202]) by ecl1mtaoutpex02.symantec.com (Symantec Brightmail Gateway out) with SMTP id 2C.AD.13305.60DFC915; Wed, 22 May 2013 17:14:46 +0000 (GMT) Received: from [155.64.220.137] (helo=TUS1XCHHUBPIN01.SYMC.SYMANTEC.COM) by ecl1mtahubpin02.ges.symantec.com with esmtp (Exim 4.76) (envelope-from ) id 1UfCcg-0008BL-N4 for pgsql-general@postgresql.org; Wed, 22 May 2013 17:14:46 +0000 Received: from TUS1XCHEVSPIN34.SYMC.SYMANTEC.COM ([155.64.220.149]) by TUS1XCHHUBPIN01.SYMC.SYMANTEC.COM ([155.64.220.137]) with mapi; Wed, 22 May 2013 10:14:44 -0700 From: Sajeev Mayandi To: "pgsql-general@postgresql.org" Date: Wed, 22 May 2013 10:14:44 -0700 Subject: DECLARING THE CURSOR WITH HOLD Thread-Topic: DECLARING THE CURSOR WITH HOLD Thread-Index: Ac5XD9qurGTHJA+aQWKRl3LUb+5N0w== Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.2.120421 acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_CDC24C6641DD9sajeevmayandisymanteccom_" MIME-Version: 1.0 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFprHIsWRmVeSWpSXmKPExsXCZeB6Spft75xAg4uLTCym393K5sDocWHf NPYAxigum5TUnMyy1CJ9uwSujCmXNjEXtPNVTO86wNzAOI+ni5GTQ0LAROL712dsELaYxIV7 64FsLg4hgXeMEre/X2aCcPqZJN4c/csO4axilDi+/xE7SAubgJHEk7ttzCC2iICjxOL7X8Bs FgFViTv7XrOA2MIC6hJX16xn7GLkAKrRkXi4OgiiXE/i4dFpYJt5BSwkNv6YClbOKWApsW7q BzCbEeii76fWMIHYzALiEreezGeCuFRAYsme88wQtqjEy8f/WEFsUaCZPx70skP0ikrcaQdZ C9IbK7GleSsjxC5BiZMzn7BMYBSdhWTsLCRls5CUQcR1JBbs/sQGYWtLLFv4mhnGPnPgMROy +AJG9lWMMqnJOYa5JYn5pSUFqRUGRnrFlbmJwDhL1kvOz93ECIy1ZUmMl3Yw3j+se4hRgINR iYdX9s+cQCHWxDKgykOMEhzMSiK81iAh3pTEyqrUovz4otKc1OJDjNIcLErivEFqUwOFBNIT S1KzU1MLUotgskwcnFINjKLvPEtb3vzry5Lq+P/urk7DdlFbzctnJP7FSMZvdynKjTDeMG1P VNf85+s/nJu7s1VP7JCFeIvFrguMgnceb5FwC9iSVrvy0MerWrMOrwqu6lnHf2hqyYOnAs38 IlN2XqxRTDV63rFF9ym/WUrnnT8axTtf7y/fN/HOvVah15zVtYkTcozV9ymxFGckGmoxFxUn AgCfKokksQIAAA== X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org --_000_CDC24C6641DD9sajeevmayandisymanteccom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 supporte= d. My code snip is. DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from phostmapp= ing; NOTE: The code is in plpgsql and postgresql version is 9.2. Thanks, Sajeev --_000_CDC24C6641DD9sajeevmayandisymanteccom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable


Hi,

I am trying to declare a cursor with hold  alon= g 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 CURS= OR WITH HOLD FOR SELECT * from phostmapping;

NOTE: The code is in plpgsql and postgresql version is 9.2.
Thanks,

Sajeev
--_000_CDC24C6641DD9sajeevmayandisymanteccom_--