Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 14.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

SELECT 1

create table property_calculation (
  id int,
  dynamic_fields jsonb
);

insert into property_calculation values 
(1, '{"totalBaseValue": 4198571.230720645844841865113039602874778211116790771484375,"surfaceAreaValue": 18.108285497586717127660449477843940258026123046875,"assessedAnnualValue": 1801819.534798908603936834409607936611000776616631213755681528709828853607177734375}'),
(2, '{"totalBaseValue": 7406547.28939837918763178237213651300407946109771728515625,"surfaceAreaValue": 31.94416993248973568597648409195244312286376953125,"assessedAnnualValue": 9121964.022681592442116216621222042691512210677018401838722638785839080810546875}');

CREATE TABLE

INSERT 0 2

update property_calculation
   set dynamic_fields = 
         jsonb_set(
           dynamic_fields, 
           '{totalBaseValue}', 
           to_jsonb((dynamic_fields->>'totalBaseValue')::numeric / 1000)
         )
 where jsonb_typeof(dynamic_fields->'totalBaseValue') = 'number';
         
UPDATE 2

select * from property_calculation;

id
dynamic_fields

1
{"totalBaseValue": 4198.571230720645844841865113039602874778211116790771484, "surfaceAreaValue": 18.108285497586717127660449477843940258026123046875, "assessedAnnualValue": 1801819.534798908603936834409607936611000776616631213755681528709828853607177734375}

2
{"totalBaseValue": 7406.54728939837918763178237213651300407946109771728516, "surfaceAreaValue": 31.94416993248973568597648409195244312286376953125, "assessedAnnualValue": 9121964.022681592442116216621222042691512210677018401838722638785839080810546875}

SELECT 2

id	dynamic_fields
1	{"totalBaseValue": 4198.571230720645844841865113039602874778211116790771484, "surfaceAreaValue": 18.108285497586717127660449477843940258026123046875, "assessedAnnualValue": 1801819.534798908603936834409607936611000776616631213755681528709828853607177734375}
2	{"totalBaseValue": 7406.54728939837918763178237213651300407946109771728516, "surfaceAreaValue": 31.94416993248973568597648409195244312286376953125, "assessedAnnualValue": 9121964.022681592442116216621222042691512210677018401838722638785839080810546875}