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