By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 1 Duplicates: 0 Warnings: 0
| JSON_PRETTY(val) |
|---|
| { "a": "value", "b": { "c": "value", "d": { "e": "value" } } } |
| result |
|---|
| ["$.a", "$.b.c", "$.b.d.e"] |
Records: 1 Duplicates: 0 Warnings: 0
| JSON_PRETTY(val) |
|---|
| { "a": "value", "b": { "c": "value", "d": { "e": "value" } } } |
| result |
|---|
| ["$.a", "$.b.c", "$.b.d.e"] |