plpgsql_procedure_dvdrental_staff

/*
Nome do procedimento: get_user_pass_from_id
IN: in_id_funcionario
INOUT: out_usuario
INOUT: out_senha
*/

CREATE OR REPLACE PROCEDURE get_user_pass_from_id(IN in_id_funcionario INT, OUT out_usuario VARCHAR, OUT out_senha VARCHAR)
language plpgsql AS $$
BEGIN
    -- corpo da procedure
    SELECT username, password INTO out_usuario, out_senha
    FROM staff
    WHERE staff_id = in_id_funcionario;
END;
$$