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
On Fri, Nov 24, 2017 at 3:46 AM, support-tiger 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';
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 wrote:
is there a way to update a single field in jsonb wit
On Thu, Nov 23, 2017 at 4:45 AM, support-tiger 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});
>
>
23.11.2017 04:45, support-tiger пишет:
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-
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
--
Support Dept
Tiger Nassau,
