From: | Oleg Bartunov <obartunov(at)gmail(dot)com> |
---|---|
To: | Andreas Heiduk <asheiduk(at)gmail(dot)com>, Дмитрий Долгов <9erthalion6(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Manipulating jsonb |
Date: | 2014-05-02 19:21:36 |
Message-ID: | CAF4Au4yPE-GqVWuNoKjNP6QT78hojyTcuvuHeS6vap_ig3mFgg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Jeff Janes | 2014-05-02 19:34:19 | Re: Vacuuming strategy |
Previous Message | Jeff Janes | 2014-05-02 19:16:15 | Re: Vacuuming strategy |