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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
