On 27-6-2015 22:15, Helen Borrie wrote: > At 05:15 a.m. 28/06/2015, Adriano dos Santos Fernandes wrote: >> On 27-06-2015 04:19, Jiřà ČinÄura wrote: >> Just a way to store the >> order you passed. > > I know it doesn't matter now, but is there a reason to >> store the order? > > > >> Extract the metadata in the same way it was created, I guess. Adriano > > 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?
I don't really understand what you mean with that. A trigger responds in reaction to an action (an insert or update), either before or after that action. It doesn't perform the action itself (it only does what is in the trigger body). Mark -- Mark Rotteveel ------------------------------------------------------------------------------ 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
