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 ------------------------------------------------------------------------------ Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical & virtual servers, alerts via email & sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
