On Fri, 27 Jan 2012 17:45:41 +0000
Rob Richardson <RDRichardson@rad-con.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