Marcos Pegoraro <mar...@f10.com.br> writes: > Alphabetical order of triggers sometimes makes me write a_Recalc or z_Calc > to be sure it´ll be the first or the last trigger with same event of that > table
> Oracle and SQL Server have FOLLOWS and PRECEDES when defining trigger > execution order. Firebird has POSITION, which I like it more. Color me skeptical: doesn't that introduce more complication without fundamentally solving anything? You still don't know which position numbers other triggers have used, so it seems like this is just a different way to spell the same problem. regards, tom lane