Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group