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

CREATE TABLE my_table
             (loval integer,
              hival integer,
              valcount integer,
              vals integer[]);
INSERT INTO my_table
            (loval,
             hival,
             valcount)
            VALUES (3,
                    22,
                    6);
1 rows affected

UPDATE my_table t
       SET vals = (SELECT array_agg(round(t.loval + (gs.n - 1) * ((t.hival - t.loval)::numeric / (t.valcount - 1))) ORDER BY gs.o)
                          FROM generate_series(1, t.valcount) WITH ORDINALITY gs (n, o));
1 rows affected

SELECT *
       FROM my_table;


loval
hival
valcount
vals


3
22
6
{3,7,11,14,18,22}