Re: Multiple TRIGGERs and OLD versus NEW "records"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Multiple TRIGGERs and OLD versus NEW "records"
Дата
Msg-id 23002.1173887062@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Multiple TRIGGERs and OLD versus NEW "records"  (Jorge Godoy <jgodoy@gmail.com>)
Ответы Re: Multiple TRIGGERs and OLD versus NEW "records"  (Jorge Godoy <jgodoy@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Trigger Question
Следующее
От: Guy Fraser
Дата:
Сообщение: Re: DST failing on 8.1.3