-- -- workflow_case_pkg__delete/1 -- create or replace function workflow_case_pkg__delete( integer ) returns int4 as $$ declare delete_case_id alias for $1; rec record; begin -- All workflow data cascades from the case id delete from workflow_cases where case_id = delete_case_id; return 0; end;$$ language plpgsql;