Re: BUG #5032: unexpected syntax error for plpgsql function returns table - Mailing list pgsql-bugs

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 <keith@cs.ucla.edu>:
> > create function reproduce() returns table(foo integer) language plpgsql as
> > 'begin return query select 1 foo; end;';