Pavel, On Thu, 3 Sep 2009, Pavel Stehule wrote:
> it's not bug - PostgreSQL doesn't support parameter placeholder on this > position. Use dynamic query instead - plpgsql statement EXECUTE. Thank you for your reply. I appreciate your suggestion, but it still seems like a bug to me. Please comment on the fact that the following code succeeds: create function reproduce() returns table(foo integer) language plpgsql as 'begin return query select 1 bar; end;'; Output in psql is: CREATE FUNCTION Why should it succeed with "bar" but not with "foo"? Thanks, Keith > 2009/9/3 Keith Cascio <ke...@cs.ucla.edu>: > > create function reproduce() returns table(foo integer) language plpgsql as > > 'begin return query select 1 foo; end;'; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
