Re: BUG #5032: unexpected syntax error for plpgsql function returns table

2009/9/3 Keith Cascio <keith@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. =C2=A0I appreciate your suggestion, but it stil=
l seems like
> a bug to me. =C2=A0Please comment on the fact that the following code suc=
ceeds:
>
> 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 <keith@cs.ucla.edu>:
>> > create function reproduce() returns table(foo integer) language plpgsq=
l as
>> > 'begin return query select 1 foo; end;';
>