'Append element to exciting json array

I have a table public."MeasurementRange", which contain some columns with information about some measurement settings. One of the field is "Range" type text. The "Range" contain information in the form of json, like

{"Field1": 43000, "Field2": 46000, "Field3": [100, 30] }
{"Field1": 44000, "Field2": 47000, "Field3": [100, 30] }
{"Field1": 45000, "Field2": 48000, "Field3": [100, 30] }
{"Field1": 46000, "Field2": 48000, "Field3": [100, 30] }

I need to create a script to add new element in "Field3". As a result I want to get something like

{"Field1": 43000, "Field2": 46000, "Field3": [100, 30, 50] }
{"Field1": 44000, "Field2": 47000, "Field3": [100, 30, 50] }
{"Field1": 45000, "Field2": 48000, "Field3": [100, 30, 50] }
{"Field1": 46000, "Field2": 48000, "Field3": [100, 30, 50] }

How to process this? Thank you in advance for your help.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source