Postgres 14

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 version();

version

PostgreSQL 14.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT split_part('АК-11 НК-82,7','-',3) as test01,
       to_number(replace(split_part('АК-11 НК-82,7','-',3),',','.'),'99999.99') AS BRLOADSTA9

test01
brloadsta9

82,7
82.7

SELECT split_part('АК-11 НК-82,8','-',3) as test01,
       to_number(replace(split_part('АК-11 НК-82,8','-',3),',','.'),'99999.99') AS BRLOADSTA9

test01
brloadsta9

82,8
82.8

SELECT split_part('ААК-11 НК-82,10','-',3) as test01,
       to_number(replace(split_part('ААК-11 НК-82,10','-',3),',','.'),'99999.99') AS BRLOADSTA9

test01
brloadsta9

82,10
82.10

SELECT split_part('ААК-11 НК-82,11','-',3) as test01,
       to_number(replace(split_part('ААК-11 НК-82,11','-',3),',','.'),'99999.99') AS BRLOADSTA9

test01
brloadsta9

82,11
82.11