> On Oct 26, 2021, at 4:01 PM, Michael Lewis <mlewis@entrata.com> wrote:
>
> Does this perform differently from suppress_redundant_updates_trigger?
>
> https://www.postgresql.org/docs/current/functions-trigger.html
If Mitar finds that suppress_redundant_updates_trigger is sufficient, that may be a simpler solution. Thanks for
mentioningit.
The suppress_redundant_updates_trigger uses memcmp on the old and new rows. I don't know if memcmp will be sufficient
inthis case, since json can be binary unequal and yet turn out to be equal once cast to jsonb. I was using the rule
andcasting the json column to jsonb before comparing for equality.
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company