Adam wrote:

>
> Perhaps both 'insert or update' and 'update or insert' could be both
> implemented, and the one you choose would determine which triggers are
> fired first.
>

for what little it's worth, Firebird triggers fire on row update, not
on verb, so an insert that fails because of a duplicate key value
doesn't file the insert trigger, nor does an update that finds no
rows. The question of "which triggers are fired first" doesn't come
up.

Regards,


Ann