Tony Caduto <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings