On Fri, Nov 24, 2017 at 3:46 AM, support-tiger <supp...@tigernassau.com> wrote: > Oleg, > > hey, thanks so much - if you are in USA visiting Yellowstone Natl Park > contact me and the beer is on me (maybe a Wyoming steak too!)
Seriously ? btw, in PG 11 we expect subscription index update test set data[age]= '30'; > > > > On 11/22/2017 11:27 PM, Oleg Bartunov wrote: >> >> On Thu, Nov 23, 2017 at 4:45 AM, support-tiger <supp...@tigernassau.com> >> wrote: >>> >>> is there a way to update a single field in jsonb without replacing the >>> entire json document - couldn't find an example >>> >>> for example >>> >>> create table test (id primary key, data jsonb); >>> >>> insert into test ({"name":"bill", "age":29}); >>> >>> ?? update test set data->age = 30 >> >> >> update test set data = jsonb_set(data, '{age}', '30'::jsonb); >> >>> >>> -- >>> Support Dept >>> Tiger Nassau, Inc. >>> www.tigernassau.com >>> 406-624-9310 >>> >>> >>> >> > > -- > Support Dept > Tiger Nassau, Inc. > www.tigernassau.com > 406-624-9310 > > >