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

From: Keith Cascio <keith(at)CS(dot)UCLA(dot)EDU>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5032: unexpected syntax error for plpgsql function returns table
Date: 2009-09-03 06:39:35
Message-ID: alpine.GSO.2.00.0909022334090.2576@kiwi.cs.ucla.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Pavel,

On Thu, 3 Sep 2009, Pavel Stehule wrote:

> 2009/9/3 Keith Cascio <keith(at)cs(dot)ucla(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2009-09-03 07:44:30 Re: [NOVICE] psql: FATAL: the database system is in recovery mode
Previous Message Pavel Stehule 2009-09-03 06:31:53 Re: BUG #5032: unexpected syntax error for plpgsql function returns table