[GENERAL] Manipulating jsonb

2014-05-02 Thread Andreas Heiduk
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

Re: [GENERAL] Manipulating jsonb

2014-05-02 Thread Oleg Bartunov
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 wrote: > Hello, > > I'm playing with a 9.4 pre

Re: [GENERAL] Manipulating jsonb

2014-05-02 Thread Oleg Bartunov
No way, Andreas ! But, we hope, Dimitri will release his extension before 9.4, so anybody could install it. Oleg On Sat, May 3, 2014 at 1:21 AM, Andreas Heiduk wrote: > Hello Oleg, > > how are the odds that the '||' and '-' operators from jsonbx will be > included in the public 9.4 release? > >

Re: [GENERAL] Manipulating jsonb

2014-05-03 Thread Andreas Heiduk
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 wrote: > Andreas, > > take a look on https://github.com/erthalion/jsonbx. This is a place, > where all hstore functionality will be ev

Re: [GENERAL] Manipulating jsonb

2014-05-03 Thread Andreas Heiduk
Hello Oleg, that's a pitty. I think at least some server-side processing for jsonb would make a round package. But I will monitor Dimitri's extension. Thank you very much for your answer. Andreas On 3 May 2014 00:26, Oleg Bartunov wrote: > No way, Andreas ! > > But, we hope, Dimitri will relea