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
