Re: update field in jsonb - Mailing list pgsql-general

From Sven R. Kunze
Subject Re: update field in jsonb
Date
Msg-id ec323314-a7e8-e69a-814e-589ddf234717@mail.de
Whole thread Raw
In response to Re: update field in jsonb  (Oleg Bartunov <obartunov@gmail.com>)
List pgsql-general
On 24.11.2017 12:19, Oleg Bartunov wrote:
> btw, in PG 11 we expect subscription index
>       update test set data[age]= '30';

Out of curiosity:

Why not?

update test set data->age= 30;

It reminds me more of how to query json in PG

select data->age from test;


Cheer,
Sven


pgsql-general by date:

Previous
From: Adam Tauno Williams
Date:
Subject: Re: How clear the cache on postgresql?
Next
From: nikhil raj
Date:
Subject: A particular database to move to other drive