Hi, It's not only Oracle having a when, PostgreSQL has something similar:
http://www.postgresql.org/docs/9.1/interactive/sql-createtrigger.html > If a WHEN clause implies that the trigger gets fired anyway, then right, > this wouldn't make a difference. ;-) I think an aspect would be a transparency of triggers because you see when they should fire in the declaration. -- Björn Reimer - RRZE ------------------------------------------------------------------------------ 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