By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
14 rows affected
jsonb_pretty |
---|
{ "School": { "Hall": { "Breath": "11", "Heught": "4", "Length": "12" }, "Room": { "Jon": "Present", "Hanna": "Absent", "Teena": "NA" }, "Ground": { "col": "oo", "else": "a", "school": "xuz" } } } |
{ "College": { "ClassA": { "others": "1", "teacher": "2", "students": "20" }, "ClassB": { "tv": "0", "Des": "3" } } } |