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

From Michael Lewis
Subject Re: Determining if a table really changed in a trigger
Date
Msg-id CAHOFxGpCuubDP48nD-+Gfj7NCbHvvjBGJ4qeOFT7QYmdhEvoNQ@mail.gmail.com
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
List pgsql-general
If you end up with no rows changing from an insert or delete, something seems awry. Unless you mean 0 rows affected. Do after statement triggers still execute? I suppose they very well might.

Would the statement even execute if no rows get updated and that is prevented with before update? I would assume null is being returned rather than old if the trigger finds the row to be identical.

pgsql-general by date:

Previous
From: Benedict Holland
Date:
Subject: Re: ZFS filesystem - supported ?
Next
From: Ron
Date:
Subject: Re: Need help understanding error message [RESOLVED]