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

From Marcos Pegoraro
Subject Re: Determining if a table really changed in a trigger
Date
Msg-id CAB-JLwauKri8Y+7GX6TZKvxziHmSEvdb2oc+kE6u2YzY5JUErw@mail.gmail.com
Whole thread Raw
In response to Re: Determining if a table really changed in a trigger  (Alban Hertroys <haramrae@gmail.com>)
Responses Re: Determining if a table really changed in a trigger
List 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 ? 

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Determining if a table really changed in a trigger
Next
From: Alban Hertroys
Date:
Subject: Re: Determining if a table really changed in a trigger