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

Re: Found small issue with OUT params

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Found small issue with OUT params
Date: 2005-09-28 19:46:59
Message-ID: 8451.1127936819@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:
> If I call it like this:
> select * from FIND_USER_SOCKET_BYNAME('juser');
> I would expect to get back 1 value with the name of the OUT param 
> (OUT_SOCKET_ADDRESS). 
> However it comes back with the name of the function

This is intentional, for compatibility with the pre-existing behavior
with functions in FROM.  A function that isn't returning a record is
effectively declared as
	FROM foo(...) AS foo(foo)
while a function that does return a record type gives you
	FROM foo(...) AS foo(col1, col2)

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2005-09-28 19:49:34
Subject: Re: Added documentation about caching, reliability
Previous:From: Tony CadutoDate: 2005-09-28 19:10:31
Subject: Found small issue with OUT params

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