Re: [Firebird-devel] Differences between triggers

2015-06-28 Thread Mark Rotteveel
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 t

Re: [Firebird-devel] Differences between triggers

2015-06-28 Thread Dmitry Yemanov
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 ke

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Helen Borrie
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

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Jiří Činčura
> Extract the metadata in the same way it was created, I guess. Funny. Because there's at least two dozens cases where the generic form is extracted. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Monitor 25 net

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Adriano dos Santos Fernandes
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 ---

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Jiří Činčura
> 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? -- Mgr. Jiří Činčura Independent IT Specialist -- Monitor 25 network devices or servers for free with

Re: [Firebird-devel] Differences between triggers

2015-06-25 Thread Adriano dos Santos Fernandes
On 25/06/2015 12:38, Jiří Činčura wrote: > Hi *, > > If I create "insert or delete" and "delete or insert" trigger these are > stored differently in a system table. Is there really a difference? > Just a way to store the order you passed. DDL triggers are stored different, using a fixed bit per t

[Firebird-devel] Differences between triggers

2015-06-25 Thread Jiří Činčura
Hi *, If I create "insert or delete" and "delete or insert" trigger these are stored differently in a system table. Is there really a difference? -- Mgr. Jiří Činčura Independent IT Specialist -- Monitor 25 network dev