Re: Returnd Refcurser ( 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