Re: Found small issue with OUT params

Tony Caduto <tony_caduto@amsoftwaredesign.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 asFROM foo(...) AS foo(foo)
while a function that does return a record type gives youFROM foo(...) AS foo(col1, col2)
        regards, tom lane