Subject Re: [firebird-support] Trigger position question
Author Martijn Tonies
Hello Daniel,

> When I define a trigger, if I omit the position statement and other
triggers
> for the same table exist, will the trigger with no position statement be
the
> last or the first. Do the positions start at zero or one?

-Max(SmallInt).

If there are multiple triggers with the same position, they will
fire in "no particular order". That is: implementation defined.
This, currently, means the will fire alphabetically, but don't
count on it.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com