You can do the same in other dbms. Just use an instead of delete trigger instead of the rule.