-- DROP FUNCTION check_versao_sistema();
CREATE OR REPLACE FUNCTION check_versao_sistema()
RETURNS trigger AS
$BODY$
BEGIN
-- Check that empname and salary are given
IF NEW.liberado IS null THEN
RAISE EXCEPTION 'liberado cannot be null';
END IF;
IF NEW.liberado = false THEN
RAISE EXCEPTION ' cannot have false to liberado';
END IF;
RETURN NEW;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION check_versao_sistema() OWNER TO postgres;
-- DROP TRIGGER check_versao_sistema ON versao_sistema;
CREATE TRIGGER check_versao_sistema
BEFORE INSERT OR UPDATE
ON versao_sistema
FOR EACH ROW
EXECUTE PROCEDURE check_versao_sistema();