Re: Order of update triggers

On Fri, 27 Jan 2012 17:45:41 +0000
Rob Richardson <RDRichardson(at)rad-con(dot)com> wrote:

> (Of course, all triggers are fired within a single transaction,
> and inside a transaction, terms like "before", "after" and
> "already" are effectively meaningless. Right?)

Absolutely not: you have "time stages", even into a single
transaction.

ie: * Table TBA contains a "price" column,
* Trigger TR1 creates an average of "price"
* If you launch TR1 BEFORE (insert), the new value you're about
to insert won't be accounted
* If you trigger TR1 AFTER (insert), it will.

And alphabetic order only matters for the same family (event)
of triggers.

--
Men will fuck mud.
-- Lenny Bruce