Good article. Must admit though I have only used triggers once to implement cascade deletes (I know problems, problems ) when I converted an Access database. Recently considered it as a method for recording a log of data updates.
This is something I will bear in mind for the future, it's great to get info like this as it will make me stop and think that one solution is not the only one.
I do wonder, that many people use triggers and I don't, that there is something wrong in the way I design databasea and build systems or maybe I'm just lucky and don't have large complex systems
Far away is close at hand in the images of elsewhere.
Anon.