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 (array['a1','b1'])[1];

array

a1

SELECT 1

select ((array[array['a1','b1'],
              array['a2','b2']] ))[1];

array

null

SELECT 1

select (array[array['a1','b1'],
              array['a2','b2']] )[1:1][:];

array

{{a1,b1}}

SELECT 1

select (array[array['a1','b1'],
              array['a2','b2']] )[2:2][:];

array

{{a2,b2}}

SELECT 1

select (array[array['a1','b1'],array['a2','b2']])[1][1];

array

a1

SELECT 1