Postgres 9.3

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

values (1); --1row, 1col

column1

1

SELECT 1

values 1;  --1row, 1col

ERROR:  syntax error at or near "1"
LINE 1: values 1;  --1row, 1col
               ^

values 6,7,8; -- 1row, 3col

ERROR:  syntax error at or near "6"
LINE 1: values 6,7,8; -- 1row, 3col
               ^

values (6),(7),(8); -- 3row, 1col

column1

6

7

8

SELECT 3

values (6,6,6),(7,7,7), (8,8,8); -- 3row, 3col

column1
column2
column3

6
6
6

7
7
7

8
8
8

SELECT 3