By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | textvalue | CAST(jsonvalue AS CHAR) |
---|---|---|
1 | [3, "xxx", 1, "aaa"] | [3, "xxx", 1, "aaa"] |
2 | {"xxx":1, "aaa":5, "sss":3} | {"aaa": 5, "sss": 3, "xxx": 1} |
3 | ["555", 555, {"333":333, "111":"111", "555":555}] | ["555", 555, {"111": "111", "333": 333, "555": 555}] |
4 | {"777":777, "555":[3,1,5], "999":{"asdf":"fdsa", "abcd":"dcba"}} | {"555": [3, 1, 5], "777": 777, "999": {"abcd": "dcba", "asdf": "fdsa"}} |