Postgres Pro
Downloads
Home   >   mailing lists

Re: jsonb merge with update ... on conflict do - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: jsonb merge with update ... on conflict do
Date
Msg-id 469851622548513@mail.yandex.ru
Whole thread Raw
In response to jsonb merge with update ... on conflict do  (Eugene Pazhitnov <pazhitnov@gmail.com>)
Responses Re: jsonb merge with update ... on conflict do  (Eugene Pazhitnov <pazhitnov@gmail.com>)
List pgsql-bugs
Tree view 
Hello
You meant 

... do update set price=test.price || '{"CA":20}'::jsonb;

? Or possibly

... do update set price=test.price || EXCLUDED.price;

?
In other words, why did you expect the result {"CA":20,"RU":10} ?

regards, Sergei

pgsql-bugs by date:

Previous
From: Eugene Pazhitnov
Date:
Subject: jsonb merge with update ... on conflict do
Next
From: Eugene Pazhitnov
Date:
Subject: Re: jsonb merge with update ... on conflict do