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?.
?column? |
---|
{"a": [1, 2, 3], "b": {"c": 3, "d": 4}, "x": [4, "h", 1]} |
[1, 2, 3, {"b": {"c": 3, "d": 4}, "x": [4, "h", 1]}] |
[{"a": [1, 2, 3], "b": {"c": 3}}, 3, "c", 1] |
{"a": "test", "b": {"c": 3}} |