Re: [Firebird-devel] Differences between triggers

[Dmitry Y. <fir...@ya...>]

Helen,

> This question makes me curious as to whether INSERT OR UPDATE and UPDATE OR INSERT are actually processed in exactly the same way, or does the order affect the execution logic?
> 
> i.e., if INSERT is the first operator, does the engine attempt INSERT and perform UPDATE if the key is found...if UPDATE is first, does the engine attempt UPDATE and perform INSERT if the key is not found?

For triggers, there's no difference. For the UPSERT command, there's no INSERT OR UPDATE statement.


Dmitry