Jorge Godoy <[EMAIL PROTECTED]> writes:
> 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?
OLD is the data actually in the database. NEW is the currently proposed row.
So prior triggers can change what you see as NEW, but not OLD.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
