Search Postgresql Archives

Re: Multiple TRIGGERs and OLD versus NEW "records"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux