Answer the question
In order to leave comments, you need to log in
How to check procedure with out parameter via plpgsql_check extension?
Installed a rather popular plpgsql linter . With functions that have only in parameters, everything works:
SELECT * from sys_addons.plpgsql_check_function('helpdesk._get_specialist(int)');
SELECT * from sys_addons.plpgsql_check_function('helpdesk.create_issue(out int4,in json)');
Answer the question
In order to leave comments, you need to log in
Well there on idea the signature in style regprocedure is transferred. OUT parameters do not affect the signature, so just:
SELECT * from sys_addons.plpgsql_check_function('helpdesk.create_issue(json)');
SELECT 'helpdesk.create_issue(json)'::regprocedure;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question