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?.
CREATE TABLE
INSERT 0 5
CREATE FUNCTION
id | js | ade | empty_input | null_input |
---|---|---|---|---|
1 | {"a": 42, "b": 43, "c": 44, "d": 97} | {"a": 42, "d": 97} | null | null |
2 | {"a": 42, "b": 43, "c": 44, "d": 97, "e": {"a": [1, 2, 3]}} | {"a": 42, "d": 97, "e": {"a": [1, 2, 3]}} | null | null |
3 | {"a": 42} | {"a": 42} | null | null |
4 | {} | null | null | null |
5 | null | null | null | null |
SELECT 5
CREATE FUNCTION
id | js | ade | empty_input | null_input |
---|---|---|---|---|
1 | {"a": 42, "b": 43, "c": 44, "d": 97} | { "a" : 42, "d" : 97 } | null | null |
2 | {"a": 42, "b": 43, "c": 44, "d": 97, "e": {"a": [1, 2, 3]}} | { "a" : 42, "d" : 97, "e" : {"a": [1, 2, 3]} } | null | null |
3 | {"a": 42} | { "a" : 42 } | null | null |
4 | {} | null | null | null |
5 | null | null | null | null |
SELECT 5
CREATE FUNCTION
id | js | ade | empty_input | null_input |
---|---|---|---|---|
1 | {"a": 42, "b": 43, "c": 44, "d": 97} | { "a" : 42, "d" : 97 } | null | null |
2 | {"a": 42, "b": 43, "c": 44, "d": 97, "e": {"a": [1, 2, 3]}} | { "a" : 42, "e" : {"a": [1, 2, 3]}, "d" : 97 } | null | null |
3 | {"a": 42} | { "a" : 42 } | null | null |
4 | {} | null | null | null |
5 | null | null | null | null |
SELECT 5