Hacker News Reader

An ON UPDATE trigger for the is_deleted column would do.

Some databases also support INSTEAD OF triggers.

Doesn't ON UPDATE only work for foreign keys? As far as I know, it's used to update the foreign key itself, and not values based on relationships.