Postgres 12

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?.

CREATE OR REPLACE FUNCTION test_numeric ()
-- RETURNS TABLE(m numeric(20,10), n numeric(20,10)) AS $$
RETURNS TABLE(m numeric, n numeric(20,10)) AS $$
BEGIN
    RETURN QUERY
    select
        -- returned as written (with more than 10 decimal places)
        88888888.88888888888888888 as mm,
        -- truncated as expected
        88888888.88888888888888888::numeric(20,10) as nn;
END;
$$ LANGUAGE plpgsql;
create or replace view v_test as
select
    9.9::numeric(20,10) as x,
    n as y
from test_numeric();
SELECT * FROM v_test


x
y


9.9000000000
88888888.8888888889