By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| json_build_object |
|---|
| {"TEXTS" : [{"TEXT":"A","sortOrder":1}, {"TEXT":"B","sortOrder":2}, {"TEXT":"C","sortOrder":3}]} |
SELECT 1
| json_build_object |
|---|
| {"TEXTS" : [{"TEXT":"A","sortOrder":1}, {"TEXT":"B","sortOrder":2}, {"TEXT":"C","sortOrder":3}]} |
SELECT 1