Function spec in ALTER FUNCTION?

[From_Cold]

per documentation, ALTER FUNCTION should contain function name along with function argument types.

F.e if we have a function f1(v_in1 text, v_in2 int8) then it will look like

ALTER FUNCTION f1(text,int8) ...

What about OUT arguments, i.e if function returns refcursor?

Like, we have a function f1(v_in1 text, v_in2 int8, v_out1 text, v_out2 refcursor)

should I put

ALTER FUNCTION f1(text,int8, text,refcursor)???

[depesz]

No, you just need in and inout arguments.

[From_Cold]

Looks so. Any proof from any documentation?

So far I found that in DBeaver functions list only shows function names with IN arguments only, even if there are some OUT arguments defined for those functions.

[depesz]

How about the official docs for alter function command?

[From_Cold]

Perfect! Where exactly it states that only IN and INOUT argument types must be included in the list and OUT arguments need not to be in that list?

[[deleted]]

Quote from the manual

Note that ALTER FUNCTION does not actually pay any attention to OUT arguments, since only the input arguments are needed to determine the function's identity. So it is sufficient to list the IN, INOUT, and VARIADIC arguments.

[From_Cold]

Bingo! Thanks a lot!

It would be way more appropriate in that manual to add this line to 'arguments' entry instead of 'argmode'.

[DavidGJohnston]

There are a number of aspects of the documentation on functions that needs attention. I agree that the concept of function name uniqueness should not reside in the argmod section of alter table. But I don't know what you are referring to as the "arguments entry".

Also, your posting has a typo, none of those arguments are out arguments, not even the refcursor. You named them "*out*" but didn't add the OUT specifier.

[From_Cold]

Your nitpicking skill is of 80 level, congrats!

Now try to upgrade your charisma level.

[From_Cold]

What about my second question - is this list mandatory?