IN, OUT AND INOUT Parameters

CREATE OR REPLACE PROCEDURE add_numbers(
     
     
       IN a INT,                -- Input parameter for the first integer
       IN b INT,                -- Input parameter for the second integer
       INOUT initial_result INT, -- INOUT parameter to receive and update the result
       INOUT final_result INT     -- Output parameter to return the final sum

)
LANGUAGE plpgsql
AS $$
BEGIN
	initial_result := a+b;
	final_result := initial_result;
END;
$$;