Postgres Pro
Downloads
Home   >   mailing lists

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

From Eugene Pazhitnov
Subject Re: jsonb merge with update ... on conflict do
Date
Msg-id CAGfKbEzELo5rE7tTTvj4gJC6Y+ZaE8c=kXWJbR9cXCDpV2kksg@mail.gmail.com
Whole thread Raw
In response to Re: jsonb merge with update ... on conflict do  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-bugs
Tree view
Thanks a lot, Sergei! My fault. Works like a charm now.

вт, 1 июн. 2021 г. в 14:58, Sergei Kornilov <sk@zsrv.org>:
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


--
Evgeny Pazhitnov

pgsql-bugs by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: jsonb merge with update ... on conflict do
Next
From: "Godfrin, Philippe E"
Date:
Subject: CREATE SERVER makes 2 entries in the dictionary