Hacker News new | ask | show | jobs
by nine_k 1522 days ago
An ON UPDATE trigger for the is_deleted column would do.

Some databases also support INSTEAD OF triggers.
1 comments
vaishnavsm 1519 days ago
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.
link