Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 4D75B9FC3FF
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 10 Aug 2007 03:35:33 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 10943-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 10 Aug 2007 03:35:28 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id 96C219FC3F9
	for <pgsql-sql@postgresql.org>; Fri, 10 Aug 2007 03:35:29 -0300 (ADT)
Received: (qmail 18461 invoked by uid 0); 10 Aug 2007 06:35:28 -0000
Received: from 84.75.95.14 by www160.gmx.net with HTTP;
	Fri, 10 Aug 2007 08:35:27 +0200 (CEST)
Cc: pgsql-sql@postgresql.org, penchalaiahp@infics.com
Content-Type: text/plain; charset="iso-8859-1"
Date: Fri, 10 Aug 2007 08:35:28 +0200
From: "Christian Kindler" <christian.kindler@gmx.net>
In-Reply-To: <20070810063103.GA7903@winnie.fuhr.org>
Message-ID: <20070810063528.206050@gmx.net>
MIME-Version: 1.0
References: <20070810061628.206070@gmx.net>
	<20070810063103.GA7903@winnie.fuhr.org>
Subject: Re: Returnd Refcurser (<unnamed portal x> not fetchable
To: Michael Fuhr <mike@fuhr.org>
X-Authenticated: #27759442
X-Flags: 0001
X-Mailer: WWW-Mail 6100 (Global Message Exchange)
X-Priority: 3
X-Provags-ID: V01U2FsdGVkX18uLZRZGsAuwdGRrFXTIwrFRURpF/WvJqkScDqnzL
	H9yrqloUR1UopCN2h1j2IQoFcob7nTKbv5sw==
Content-Transfer-Encoding: 8bit
X-GMX-UID: BjKOfkpjPjl+GmenkTQ2H8E7MTE2Ncl/
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.504 tagged_above=0 required=5 tests=AWL=0.503,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200708/74
X-Sequence-Number: 29012

Ohhh Yes! 

Thanks al lot. Sometimes you can't see the wood for the trees.

Thanks!
Chris



-------- Original-Nachricht --------
Datum: Fri, 10 Aug 2007 00:31:03 -0600
Von: Michael Fuhr <mike@fuhr.org>
An: Christian Kindler <christian.kindler@gmx.net>
CC: "Penchalaiah P." <penchalaiahp@infics.com>, pgsql-sql@postgresql.org
Betreff: Re: [SQL] Returnd Refcurser (<unnamed portal x> not fetchable

> On Fri, Aug 10, 2007 at 08:16:28AM +0200, Christian Kindler wrote:
> > select * from getfoo('M');
> > -- fetch all in '<unnamed portal 14>';
> > 
> > ERROR:  syntax error at or near "'<unnamed portal 14>'" at character 15
> 
> The cursor name is an identifier so use double quotes instead of
> single quotes.  Also, when using non-holdable cursors you'll need
> to be in a transaction block.
> 
> begin;
> select * from getfoo('M');
> fetch all in "<unnamed portal 14>";
> commit;
> 
> -- 
> Michael Fuhr

-- 
cu
Chris

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer