Re: update field in jsonb

From: "Sven R(dot) Kunze" <srkunze(at)mail(dot)de>
To: obartunov(at)gmail(dot)com, support-tiger <support(at)tigernassau(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: update field in jsonb
Date: 2017-11-25 20:00:56
Message-ID: ec323314-a7e8-e69a-814e-589ddf234717@mail.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message nikhil raj 2017-11-25 20:03:53 Roles and security
Previous Message Adam Tauno Williams 2017-11-25 15:01:43 Re: How clear the cache on postgresql?