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.

Mark

------------------------------------------------------------------------------
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

Reply via email to