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

From Keith Cascio
Subject Re: BUG #5032: unexpected syntax error for plpgsql function returns table
Date
Msg-id alpine.GSO.2.00.0909022334090.2576@kiwi.cs.ucla.edu
Whole thread Raw
In response to Re: BUG #5032: unexpected syntax error for plpgsql function returns table  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-bugs
Pavel,

On Thu, 3 Sep 2009, Pavel Stehule wrote:

> 2009/9/3 Keith Cascio <keith@cs.ucla.edu>:
> > Why should it succeed with "bar" but not with "foo"?
>
> because bar isn't declared as variable

I understand now.  returns table(v1 t1, v2 t2,...) is equivalent to declaring
OUT parameters, therefore "foo" is an out parameter.  Thank you for your
patience sir.

Keith

pgsql-bugs by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: BUG #5032: unexpected syntax error for plpgsql function returns table
Next
From: Robert Haas
Date:
Subject: Re: BUG #5032: unexpected syntax error for plpgsql function returns table