Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Uevy2-0006nk-1C for pgus-general@arkaria.postgresql.org; Tue, 21 May 2013 23:27:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Uevy1-00047j-HC for pgus-general@arkaria.postgresql.org; Tue, 21 May 2013 23:27:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Uevy0-000477-KC for pgus-general@postgresql.org; Tue, 21 May 2013 23:27:40 +0000 Received: from tus1smtoutpex02.symantec.com ([216.10.195.242]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uevxw-0007yO-8G for pgus-general@postgresql.org; Tue, 21 May 2013 23:27:40 +0000 X-AuditID: d80ac3f2-b7f276d00000036d-d3-519c02e6b119 Received: from tus1smtintpin01.ges.symantec.com (tus1smtintpin01.ges.symantec.com [192.168.215.101]) by tus1smtoutpex02.symantec.com (Symantec Brightmail Gateway out) with SMTP id EF.29.00877.6E20C915; Tue, 21 May 2013 23:27:34 +0000 (GMT) Received: from [155.64.220.137] (helo=TUS1XCHHUBPIN01.SYMC.SYMANTEC.COM) by tus1smtintpin01.ges.symantec.com with esmtp (Exim 4.76) (envelope-from ) id 1Uevxu-0000kD-In for pgus-general@postgresql.org; Tue, 21 May 2013 23:27:34 +0000 Received: from TUS1XCHEVSPIN34.SYMC.SYMANTEC.COM ([155.64.220.149]) by TUS1XCHHUBPIN01.SYMC.SYMANTEC.COM ([155.64.220.137]) with mapi; Tue, 21 May 2013 16:27:31 -0700 From: Sajeev Mayandi To: "pgus-general@postgresql.org" Date: Tue, 21 May 2013 16:27:30 -0700 Subject: DECLARING THE CURSOR WITH HOLD Thread-Topic: DECLARING THE CURSOR WITH HOLD Thread-Index: Ac5WesNvZ4g0JEYfStWp6U7mCdeIeg== Message-ID: 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_CDC1527B41A53sajeevmayandisymanteccom_" MIME-Version: 1.0 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFprIIsWRmVeSWpSXmKPExsVyYMX1VN1nTHMCDSa/Ube4srCFxYHR48K+ aewBjFFcNimpOZllqUX6dglcGX1Xp7AWPOequPN4F3sD4yrOLkZODgkBE4nzsyeyQ9hiEhfu rWcDsYUEPjJKvN4g18XIBWT3MUksbzvOCOGsYpR4cOMEWBWbgJHEk7ttzCC2iIC9xKmeLSwg NouAqsT0BZsYQWxhAXWJq2vWA9kcQDU6Eg9XB0GU60msf3wObAyvgIXE5v33wcoZgY74fmoN E4jNLCAucevJfCaI4wQkluw5zwxhi0q8fPyPFcQWBZrz40EvO0SvqMSd9vWMEL2xEncmz2OC mC8ocXLmE5YJjCKzkIydhaRsFpIyiLiOxILdn9ggbG2JZQtfM8PYZw48ZkIWX8DIvopRpqS0 2LA4tyS/tKQgtcLASK+4MjcRGE3Jesn5uZsYgRF1g+vwpx2MN5YqHmIU4GBU4uH9+292oBBr YhlQ5SFGCQ5mJRFew2tAId6UxMqq1KL8+KLSnNTiQ4zSHCxK4rxfu6YHCgmkJ5akZqemFqQW wWSZODilGhjtH0511/7H2pBRdzNY1Ogce+Qe78Q/u1iPLJ2wyf3jkTmXxNX1//x8t/eb5iXd XQrRgQ9XLLbg2Pj0QLPimc0XQk99fTThCluvgNiJXTPabvOdXRtwd4bigS5u5u5i7902Ztns HfNyr34yvV57IC49/f28tVPYBee++J4YUL6S6+UiXitD3/xZSizFGYmGWsxFxYkARzuM1aQC AAA= X-Pg-Spam-Score: -0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgus-general Precedence: bulk Sender: pgus-general-owner@postgresql.org --_000_CDC1527B41A53sajeevmayandisymanteccom_ 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. Thanks, Sajeev --_000_CDC1527B41A53sajeevmayandisymanteccom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hi,

=
I am trying to declare a cursor with hold  along with NO SCROLL o= ption.  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 S= ELECT * from phostmapping;

NOTE: The code i= s in plpgsql.

Thanks,

Saj= eev
--_000_CDC1527B41A53sajeevmayandisymanteccom_--