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