On Wed, Apr 27, 2005 at 10:38:48AM -0600, mmiranda@xxxxxxxxxxxxxxxxx wrote: > > What about performance, if its a matter of choice between after or before > insert, what perform better? According to the "Triggers" chapter in the documentation, "If you have no specific reason to make a trigger before or after, the before case is more efficient, since the information about the operation doesn't have to be saved until end of statement." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend