Re: jsonb merge with update ... on conflict do

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Eugene Pazhitnov <pazhitnov(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: jsonb merge with update ... on conflict do
Date: 2021-06-01 11:58:04
Message-ID: 469851622548513@mail.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Eugene Pazhitnov 2021-06-01 12:18:49 Re: jsonb merge with update ... on conflict do
Previous Message Eugene Pazhitnov 2021-06-01 11:53:10 jsonb merge with update ... on conflict do