Subject Re: [firebird-support] Trigger Position
Author Ann W. Harrison
ShepherdHill DB Subscriptions wrote:
> Hi,
> Does trigger position counts for the whole table or for each trigger type?

Triggers are sorted first by action time, then by position.

The trigger position indicates the order of action of triggers
for a action time - e.g. BEFORE UPDATE. If you have several
BEFORE UPDATE triggers for a table, use the position to indicate
the order in which they should run. If you have both BEFORE
UPDATE and AFTER UPDATE triggers for a table, all the BEFORE
UPDATE triggers will run before the action and the AFTER UPDATE
triggers will run after the update, even if the position indicated
for the AFTER UPDATE triggers are 1, 2, 3 and the position of
the BEFORE UPDATE triggers are 100, 101, 102.