-- -- workflow_case__clear_manual_assignments/2 -- create or replace function workflow_case__clear_manual_assignments( integer, character varying ) returns int4 as $$ declare clear_manual_assignments__case_id alias for $1; clear_manual_assignments__role_key alias for $2; v_workflow_key varchar; begin select workflow_key into v_workflow_key from wf_cases where case_id = clear_manual_assignments__case_id; delete from wf_case_assignments where workflow_key = v_workflow_key and case_id = clear_manual_assignments__case_id and role_key = clear_manual_assignments__role_key; return 0; end;$$ language plpgsql;