'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 |
|---|
