Re: Determining if a table really changed in a trigger

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: Mitar <mmitar(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Determining if a table really changed in a trigger
Date: 2021-10-26 14:16:18
Message-ID: CAB-JLwauKri8Y+7GX6TZKvxziHmSEvdb2oc+kE6u2YzY5JUErw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> Don’t use this approach with JSON (as opposed to JSONB) type fields
> though, a single extra space in the JSON structure would already lead to a
> difference, as would other formatting differences.
>
> I don´t think two equal values being converted to json will be different
in any way. If row_to_json of both are different, I suppose both record
really are different, no ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2021-10-26 14:39:28 Re: Determining if a table really changed in a trigger
Previous Message Alban Hertroys 2021-10-26 14:05:42 Re: Determining if a table really changed in a trigger