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 309/16

?column?

19

SELECT 1

select 309::numeric/16

?column?

19.3125000000000000

SELECT 1

select trunc(309::numeric/16,1)

trunc

19.3

SELECT 1