Getting a delta of two json-typed objects? (a breeze w/ hstore)

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Getting a delta of two json-typed objects? (a breeze w/ hstore)
Date: 2015-01-22 19:37:32
Message-ID: CAOC+FBVh10wcRfcEPpm8MRMA2iK7DJjbwtS-n3Wq1PdJOWa-Fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all. I have a trigger function which does a delta of two hstore values
just doing a - b; this check is performed to see if there's a delta and if
not I don't log it.

I'm wondering if there's a suitable method for comparison two json objects?
I don't have 9.4 yet so I can't use jsonb, but if there's any input here
I'd appreciate it.

Thanks.

--
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2015-01-22 19:48:05 Re: Getting a delta of two json-typed objects? (a breeze w/ hstore)
Previous Message Igal @ getRailo.org 2015-01-22 19:30:04 Re: pg_upgrade could not connect to server