Postgres Pro
Downloads
Home   >   mailing lists

Re: Determining if a table really changed in a trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Determining if a table really changed in a trigger
Date
Msg-id 497190.1636206201@sss.pgh.pa.us
Whole thread Raw
In response to Re: Determining if a table really changed in a trigger  (Mitar <mmitar@gmail.com>)
Responses Re: Determining if a table really changed in a trigger  (Mitar <mmitar@gmail.com>)
List pgsql-general
Tree view 
Mitar <mmitar@gmail.com> writes:
> Anyone? Any way to determine the number of affected rows in a statement trigger?

Check the size of the transition relation.

            regards, tom lane

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Question: Is it possible to get the new xlog position after query execution?
Next
From: Mitar
Date:
Subject: Re: Determining if a table really changed in a trigger