Re: Multiple TRIGGERs and OLD versus NEW "records"

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Jorge Godoy <jgodoy(at)gmail(dot)com> 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(at)gmail(dot)com>