Re: Multiple TRIGGERs and OLD versus NEW "records"

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Jorge Godoy <jgodoy@gmail.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@gmail.com>