This way would be interesting for those are migrating from these databases too. But ok, I´ll forget it.
Em qua., 15 de set. de 2021 às 08:40, Tom Lane <t...@sss.pgh.pa.us> escreveu: > 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 >