Thanks a lot, Sergei! My fault. Works like a charm now.
вт, 1 июн. 2021 г. в 14:58, Sergei Kornilov <sk(at)zsrv(dot)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