> 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

Reply via email to