Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgus-general-owner+M279=pgus+2Dgeneral=arkaria.postgresql.org@postgresql.org>)
	id 1UexMh-0002Gd-Cv
	for pgus-general@arkaria.postgresql.org; Wed, 22 May 2013 00:57:15 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgus-general-owner+M279=pgus+2Dgeneral=arkaria.postgresql.org@postgresql.org>)
	id 1UexMg-0007IL-OG
	for pgus-general@arkaria.postgresql.org; Wed, 22 May 2013 00:57:14 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>) id 1UexMg-0007IG-3q
	for pgus-general@postgresql.org; Wed, 22 May 2013 00:57:14 +0000
Received: from mail-da0-x235.google.com ([2607:f8b0:400e:c00::235])
	by makus.postgresql.org with esmtp (Exim 4.80)
	(envelope-from <adrian.klaver@gmail.com>) id 1UexMZ-0000aB-OW
	for pgus-general@postgresql.org; Wed, 22 May 2013 00:57:13 +0000
Received: by mail-da0-f53.google.com with SMTP id t11so774999daj.40
	for <pgus-general@postgresql.org>; Tue, 21 May 2013 17:57:06 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	bh=mn70nws8BVyLG+6VLrGaWInyOKlh3tyFtHM34jaGZvU=;
	b=rFbZPOCAEUuGbLcf306+v/NEjF7BX5fAar/5Kk/A/0W3GKmaY01vCt6wXbM8wQB3ws
	4viwLGquJZlcIRuTZssK1N9cT6Nb9TeI/m46nDzAqflhqRJhEyH9MkNAXvOuQ3ayRBa/
	mp0taOZMJo11bWyaiOUfZlTvsjvKR0XZfkKsrM59DrWiTfJvbe236nRdyT3RzoViCfyI
	GWY1Q3F1N2RWNHRMUGyZAVLbuelQFj9ASLmN9aHssIq72I/EQ6y/MxswWd82hi+pVoUx
	nssduRK98Q3ZvPDZ5zeA+obmwJTmG7cy23qJJDIaaGhBGgnyPEOSJcl0xgmAPw3J8Dv7
	3cvA==
X-Received: by 10.68.236.68 with SMTP id us4mr4791761pbc.119.1369184226172;
	Tue, 21 May 2013 17:57:06 -0700 (PDT)
Received: from [192.168.1.2] (174-21-199-249.tukw.qwest.net. [174.21.199.249])
	by mx.google.com with ESMTPSA id
	do4sm4789288pbc.8.2013.05.21.17.57.04 for <multiple recipients>
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Tue, 21 May 2013 17:57:05 -0700 (PDT)
Message-ID: <519C17DF.1050709@gmail.com>
Date: Tue, 21 May 2013 17:57:03 -0700
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version: 1.0
To: Sajeev Mayandi <Sajeev_Mayandi@symantec.com>
CC: "pgus-general@postgresql.org" <pgus-general@postgresql.org>
Subject: Re: DECLARING THE CURSOR WITH HOLD
References: <CDC1527B.41A53%sajeev_mayandi@symantec.com>
In-Reply-To: <CDC1527B.41A53%sajeev_mayandi@symantec.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: 0.7 (/)
List-Archive: <http://archives.postgresql.org/pgus-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgus-general.postgresql.org>
List-Owner: <mailto:pgus-general-owner@postgresql.org>
List-Post: <mailto:pgus-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgus-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgus-general>
X-Mailing-List: pgus-general
Precedence: bulk
Sender: pgus-general-owner@postgresql.org

On 05/21/2013 04:27 PM, Sajeev Mayandi wrote:
> 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.

Two things.

1) The correct list for questions like this is:

pgsql-general

You can subscribe here:
http://www.postgresql.org/community/lists/subscribe/

2) When you resubmit this post the following information would be helpful:

Postgres version

The actual error message

The DECLARE statement in context, in other words show as much of the 
plpgsql code as possible.

>
> Thanks,
>
> Sajeev


-- 
Adrian Klaver
adrian.klaver@gmail.com


-- 
Sent via pgus-general mailing list (pgus-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgus-general