Postgres 11

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 T (ID INT, FOO INT);
INSERT INTO T VALUES (1,1),(1,2),(1,3);
3 rows affected

SELECT * FROM T WHERE ID * 1;
ERROR:  argument of WHERE must be type boolean, not type integer
LINE 1: SELECT * FROM T WHERE ID * 1;
                              ^