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 test(col1 INT, col2 INT)
INSERT INTO test(col1, col2)
VALUES (0, 0), (0, 1), (0, NULL),
(1, 0), (1, 1), (NULL, 0), (NULL, NULL);
7 rows affected
SELECT *,
col1 IS NOT DISTINCT FROM col2 AS "<=>"
FROM test
| col1 | col2 | <=> |
|---|---|---|
| 0 | 0 | t |
| 0 | 1 | f |
| 0 | null | f |
| 1 | 0 | f |
| 1 | 1 | t |
| null | 0 | f |
| null | null | t |