CREATE OR REPLACE FUNCTION office.get_role_id_by_role_code(text) RETURNS integer LANGUAGE plpgsql AS $function$ BEGIN RETURN role_id FROM office.roles WHERE role_code=$1; END $function$