Tom Lane <[EMAIL PROTECTED]> writes:
> 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
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 <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
