By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| json_agg |
|---|
| [{"id" : "a0", "children" : [{"id" : "b0", "children" : [{"id" : "c0", "items" : [1]}, {"id" : "c1", "items" : [2, 3]}]}, {"id" : "b1", "children" : [{"id" : "c2", "items" : [4]}]}]}, {"id" : "a1", "children" : [{"id" : "b1", "children" : [{"id" : "c3", "items" : [5]}]}, {"id" : "b2", "children" : [{"id" : "c0", "items" : [6]}]}]}] |