Postgres 12

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?.

SELECT (1,2) = (1,NULL)

?column?

null

SELECT ((1,2),1) = ((1,CAST(NULL AS INT)),1)

?column?

f

SELECT ((1,2),1) = ((1,NULL),1)
ERROR:  cannot compare dissimilar column types integer and unknown at record column 2

SELECT ((1,2),CAST(NULL AS INT)) = ((1,CAST(NULL AS INT)),1)

?column?

f

SELECT ((1,2),null) = ((1,null),1)
ERROR:  cannot compare dissimilar column types integer and unknown at record column 2