Postgres 17

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 version();

version

PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

CREATE TABLE tbl (cln int);

CREATE TABLE

SELECT cln bar, bar "foo" FROM tbl;

ERROR:  column "bar" does not exist
LINE 1: SELECT cln bar, bar "foo" FROM tbl;
                        ^

SELECT cln bar, "bar" "foo" FROM tbl;

ERROR:  column "bar" does not exist
LINE 1: SELECT cln bar, "bar" "foo" FROM tbl;
                        ^

SELECT cln "bAr", bar "foo" FROM tbl;

ERROR:  column "bar" does not exist
LINE 1: SELECT cln "bAr", bar "foo" FROM tbl;
                          ^

SELECT cln "bAr", "bAr" "foo" FROM tbl;

ERROR:  column "bAr" does not exist
LINE 1: SELECT cln "bAr", "bAr" "foo" FROM tbl;
                          ^