> On Mon, 10 Oct 2011 08:17:19 +0200, Thomas Steinmaurer > <t...@iblogmanager.com> wrote: >> Hello, >> >> is there any plan for supporting conditional trigger firing as in Oracle > >> when specifying an optional WHEN clause in the trigger DDL syntax? >> >> Currently in Firebird, to omit trigger code execution, one can wrap the >> entire trigger body into an IF block, but the trigger still fires, but >> no PSQL code is executed. >> >> So the question is: Is it worth to think about conditional trigger >> firing or is trigger firing in Firebird that cheap, so we don't have to >> bother? > > I think that the Oracle WHEN-clause is simply syntactic sugar for wrapping > the entire body in an IF-condition. I don't think there would be much > difference performance-wise.
If a WHEN clause implies that the trigger gets fired anyway, then right, this wouldn't make a difference. ;-) Regards, Thomas ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel