Subject Re: [IBDI] Order of triggers with same position number?
Author Ann Harrison
At 02:12 AM 6/15/00 -0400, Claudio Valderrama C. wrote:
>LangRef in page 81 says at the end:
>«Triggers for a table need not be consecutive; triggers on the same action
>with the same position number will fire in random order.»
>
>Is this ok still? Why did I have the idea that there was some order among
>triggers that share the same POSITION... or do I need vacations?

Whether or not you need a vacation, I believe that if you have
three triggers defined as "before update position 8" they will
fire after all "before update" triggers with a position less
than 8, which includes those with no defined position, before all
those with a position higher than 8, and in an arbitrary order
among themselves.

Ann