Re: update field in jsonb

On Fri, Nov 24, 2017 at 3:46 AM, support-tiger <support(at)tigernassau(dot)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 <support(at)tigernassau(dot)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
>
>
>