Re: [firebird-support] Check constraints vs. user defined triggers

2015-01-05 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Hi Ann, I ran a test and there is no performance difference, so I'll keep using check constraints as they are simpler. Thanks for your suggestion. Aldo El 04/01/15 a las 15:31, Ann Harrison aharri...@ibphoenix.com [firebird-support] escibiĆ³: On Dec 29, 2014, at 9:56 PM, Aldo

Re: [firebird-support] Check constraints vs. user defined triggers

2015-01-04 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Dec 29, 2014, at 9:56 PM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: No one has answered, so I'll offer a not-very interesting suggestion. I have a table with four check constraints, which basically check logical conditions

[firebird-support] Check constraints vs. user defined triggers

2014-12-29 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Hi, I have a table with four check constraints, which basically check logical conditions between its fields. In order to enforce those constraints, Firebird creates behind the scenes two triggers for each one of them (I suppose one for update and the other for insert operation). So in this