Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Jorge Godoy <jgodoy@xxxxxxxxx> 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 Thanks, Tom. It's like I supposed. I was going to test it tonight when I get to my office but you saved me from that :-) -- Jorge Godoy <jgodoy@xxxxxxxxx>
