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
---------------------------(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
