Postgres 16

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 123::int / 1230::int;
-- result: 0

?column?

0

SELECT 1

select 100.0 * (123::int / 1230::int); -- 100.0 * 0
-- result: 0.0

?column?

0.0

SELECT 1

select (100.0 * 123::int) / 1230::int; -- 12300.0 / 1230

?column?

10.0000000000000000

SELECT 1