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 <[EMAIL PROTECTED]>
An: Christian Kindler <[EMAIL PROTECTED]>
CC: "Penchalaiah P." <[EMAIL PROTECTED]>, 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
