R
R
romaro2022-03-23 16:50:09
PostgreSQL
romaro, 2022-03-23 16:50:09

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)');


And how to call functions/procedures with out-parameters? This option does not work:
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

1 answer(s)
G
galaxy, 2022-03-23
@romaro

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)');

you can check first by custom to regprocedure:
SELECT 'helpdesk.create_issue(json)'::regprocedure;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question