I have a situation where I could impose a constraint by a rather complicatet CHECK table constraint, or I could define an ON INSERT OR UPDATE trigger that would abort the transaction if the validation doesn't succeed. Is there any advise in favor of one of the solutions?
