From: | Andreas Heiduk <asheiduk(at)gmail(dot)com> |
---|---|
To: | obartunov(at)gmail(dot)com |
Cc: | Дмитрий Долгов <9erthalion6(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Manipulating jsonb |
Date: | 2014-05-02 21:21:38 |
Message-ID: | CAFhHFByCttkai0bYV2skZOfbEqcZ8C9yX0QkF-B9-OM8c=mjTQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Oleg,
how are the odds that the '||' and '-' operators from jsonbx will be
included in the public 9.4 release?
Andreas
On 2 May 2014 21:21, Oleg Bartunov <obartunov(at)gmail(dot)com> wrote:
> Andreas,
>
> take a look on https://github.com/erthalion/jsonbx. This is a place,
> where all hstore functionality will be eventually ported. See this
> table - https://gist.github.com/erthalion/10890778
>
> Oleg
>
> On Fri, May 2, 2014 at 10:32 PM, Andreas Heiduk <asheiduk(at)gmail(dot)com> wrote:
>> Hello,
>>
>> I'm playing with a 9.4 preview and the upcoming jsonb datatype. But
>> I'm missing the basic modification syntax.
>>
>> Given the following situation:
>>
>> CREATE TABLE test(key int, jsonval jsonb);
>> INSERT INTO test VALUES(1, '{"a": 1, "c": 3}');
>>
>> How can I UPDATE that row with '{"b": 2, "d": 4}' ? Something like
>> this does not work:
>>
>> UPDATE test SET jsonval = jsonval || '{"a": 1, "c": 3}'::jsonb
>> where key = 1;
>>
>> The result should be
>>
>> {"a": 1, "b": 2, "c": 3, "d": 4}
>>
>> The same goes for removing values.
>>
>> Did I overlook something obvious or is there really no way to do that right now?
>>
>> Best regards,
>> Andreas Heiduk
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Tim van der Linden | 2014-05-02 21:45:23 | Re: Full text: Ispell dictionary |
Previous Message | Adrian Klaver | 2014-05-02 19:45:00 | Re: Timeouts after upgrade from 9.0 to 9.3 |