2009/9/3 Keith Cascio <ke...@cs.ucla.edu>: > 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"?
because bar isn't declared as variable regards Pavel > > 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
