Re: update field in jsonb

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!)


On 11/22/2017 11:27 PM, Oleg Bartunov wrote:
> On Thu, Nov 23, 2017 at 4:45 AM, support-tiger <support@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