Postgres 10

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 cast('324342' as double);

ERROR:  type "double" does not exist
LINE 1: select cast('324342' as double);
                                ^

select cast('132342' as double precision);

float8

132342

SELECT 1

select cast('132342' as float);

float8

132342

SELECT 1