Re: BUG #15573: Need more clarification in Json - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #15573: Need more clarification in Json
Date
Msg-id CAKFQuwavCh_nbtfms13qSAA0f=rxRkYpVnHu-WOOwYJCpMP33A@mail.gmail.com
Whole thread Raw
In response to BUG #15573: Need more clarification in Json  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Thursday, January 3, 2019, PG Bug reporting form <noreply@postgresql.org> wrote:

Bug reference:      15573
Logged by:          selva kumaran

 
Please don’t use the bug reporting list for basic user questions.

Right now the issue is my business user needs only the particular column
which have changed from old to new not the whole json record.
i.e i need a select query to find the difference between two json columns(
v_old_data and v_new_data ).

Apply json_each_text to both values, full join on the keys, and filter out pairs with matching values?

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15573: Need more clarification in Json
Next
From: David Rowley
Date:
Subject: Re: BUG #15572: Misleading message reported by "Drop functionoperation" on DB with functions having same name