| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Wells Oliver <wellsoliver(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Getting a delta of two json-typed objects? (a breeze w/ hstore) |
| Date: | 2015-01-22 19:48:05 |
| Message-ID: | CAFj8pRAM6SeqatC495BAg8zkHCpVJ=N4Hq0_mnzhqf6nk_Eacg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
it should to work for JSON too
http://8kb.co.uk/blog/2015/01/16/wanting-for-a-hstore-style-delete-operator-in-jsonb/
Regards
Pavel
2015-01-22 20:37 GMT+01:00 Wells Oliver <wellsoliver(at)gmail(dot)com>:
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Felix Kunde | 2015-01-22 20:00:26 | Re: Getting a delta of two json-typed objects? (a breeze w/ hstore) |
| Previous Message | Wells Oliver | 2015-01-22 19:37:32 | Getting a delta of two json-typed objects? (a breeze w/ hstore) |