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 table my_table
(
  loval INTEGER ,
  hival INTEGER ,
  valcount INTEGER ,
  vals INTEGER[]
);
insert into my_table(loval, hival, valcount)
values
(1,10,9),
(3,22,6),
(2,42,8);
3 rows affected

update my_table
  set vals = array_append(array_prepend(loval,array(select (loval + (n-1) * ((hival - loval)::decimal / (valcount- 1)))::int 
             from generate_series(2, valcount-1) as n)),hival);
3 rows affected

select *
from my_table;


loval
hival
valcount
vals


1
10
9
{1,2,3,4,6,7,8,9,10}

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

2
42
8
{2,8,13,19,25,31,36,42}

loval	hival	valcount	vals
1	10	9	{1,2,3,4,6,7,8,9,10}
3	22	6	{3,7,11,14,18,22}
2	42	8	{2,8,13,19,25,31,36,42}