不带参数

teledb=# create or replace procedure p_no_para() as
$$
begin
    raise notice 'no_para procedure';
end;
$$
language plpgsql;
CREATE PROCEDURE
teledb=# call p_no_para();                       
NOTICE:  no_para procedure
CALL
teledb=#

带参数

teledb=# create or replace procedure p_para(a_int integer) as
$$
begin
    raise notice 'a_int = %',a_int;
end;
$$
language plpgsql;
CREATE PROCEDURE
teledb=# call p_para(1);
NOTICE:  a_int = 1
CALL
teledb=#