Re: Found small issue with OUT params

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

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