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  6::float/3.3 as number;

number

1.8181818181818183

SELECT 1

select  round(6::float/3.3,4) as number;

ERROR:  function round(double precision, integer) does not exist
LINE 1: select  round(6::float/3.3,4) as number;
                ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

select pg_typeof(6::float/3.3) as number_type;

number_type

double precision

SELECT 1

select round(6/3.3,4) as number;

number

1.8182

SELECT 1