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?.
str | array_to_string |
---|---|
1~2~3~4~5~6~7~8 | 4~5~6~7~8 |
7~8~22~99~1 | 99~1 |
1~2 |
str | regexp_replace |
---|---|
1~2~3~4~5~6~7~8 | 4~5~6~7~8 |
7~8~22~99~1 | 99~1 |
1~2 | 1~2 |
str | regexp_replace |
---|---|
1~2~3~4~5~6~7~8 | 4~5~6~7~8 |
7~8~22~99~1 | 99~1 |
1~2 | 1~2 |
str | retval |
---|---|
1~2~3~4~5~6~7~8 | 4~5~6~7~8 |
7~8~22~99~1 | 99~1 |