By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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);
✓
SELECT *,
col1 IS NOT DISTINCT FROM col2 AS "<=>"
FROM test
| col1 | col2 | <=> |
|---|---|---|
| 0 | 0 | 1 |
| 0 | 1 | 0 |
| 0 | null | 0 |
| 1 | 0 | 0 |
| 1 | 1 | 1 |
| null | 0 | 0 |
| null | null | 1 |