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 1701 / 84936;

?column?

0

SELECT 1

select 1701.0 / 84936;
-- or

?column?

0.02002684374116982198

SELECT 1

SELECT 1.0 * 1701 / 84936;
-- or

?column?

0.02002684374116982198

SELECT 1

SELECT CAST(1701 AS NUMERIC(10,4))/84936;

?column?

0.02002684374116982198

SELECT 1