Re: Multiple TRIGGERs and OLD versus NEW "records" - Mailing list pgsql-general

From Tom Lane
Subject Re: Multiple TRIGGERs and OLD versus NEW "records"
Date
Msg-id 23002.1173887062@sss.pgh.pa.us
Whole thread Raw
In response to Multiple TRIGGERs and OLD versus NEW "records"  (Jorge Godoy <jgodoy@gmail.com>)
Responses Re: Multiple TRIGGERs and OLD versus NEW "records"  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Trigger Question
Next
From: Guy Fraser
Date:
Subject: Re: DST failing on 8.1.3