Hi!
(Consider these UPDATE triggers)
I can't test this for now since I'm not with a test database handy for now,
but I was thinking on what happens to OLD and NEW when running multiple
triggers.
For example, for the first trigger OLD is the equivalent to the data that is
stored at the database already, NEW is the data I'm sending to the database.
If I change some column -- e.g. fill in some automatic calculated column or a
timestamp column --, when I run the second trigger will OLD be the data stored
at the database already or will it be affected by the NEW data returned from
the previous trigger?
I know that NEW propagates, but does OLD change? I suppose not and I can't
confirm that now... If anyone has the answer, sharing would be nice. If I
don't get any answer, I'll test and post the results later. :-)
TIA,
--
Jorge Godoy <jgodoy@gmail.com>