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?.
4 rows affected
| id | arr |
|---|---|
| 1 | {{a,b,c},{d,test1,sample1}} |
| 2 | {{sample2,sample3,sample4}} |
| 3 | null |
| 4 | {{sample6,sample7,"test done"}} |
| id | col1 | col2 | col3 |
|---|---|---|---|
| 1 | a | b | c |
| 1 | d | test1 | sample1 |
| 2 | sample2 | sample3 | sample4 |
| 3 | null | null | null |
| 4 | sample6 | sample7 | test done |