Re: Returnd Refcurser ( not fetchable

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