multiply a value of each item of a json array, PostgreSQL

Language: Layout:

--PostgreSQL 9.5
--'\\' is a delimiter

drop table if exists product;

create table product as
select uuid 'cc80c862-c264-4bfe-a929-a52478c8d59e' id,
       json $json$
           [
               {
                   "to": 10,
                   "from": 5,
                   "price": 1
               },
               {
                   "to": 20,
                   "from": 15,
                   "price": 1298000
               },
               {
                   "to": 30,
                   "from": 25,
                   "price": 500000
               }
           ]
       $json$ range_price_list_values;

select id, jsonb_pretty(range_price_list_values::jsonb) before_update from product;

update product
set    range_price_list_values = (
         select jsonb_agg(case
                  when jsonb_typeof(elem -> 'price') = 'number'
                  then jsonb_set(elem, array['price'], to_jsonb((elem ->> 'price')::numeric * 1000))
                  else elem
                end)
         from   jsonb_array_elements(range_price_list_values::jsonb) elem
       )::json;

select id, jsonb_pretty(range_price_list_values::jsonb) after_update from product;


absolute service time: 0,51 sec