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?.
with long_string (ls) as (
select unnest(string_to_array(str, E'\n'))
from (values ('Buying on Saturday, delivery by XXX, address YYY, payment method ZZZ
Please quote us on prices and stock availability
К52-1Б - 68мкф/50в
К52-1 - 100мкф/63в')
) v(str)
)
select ls, string_to_array(ls, E'\n')
from long_string
| ls | string_to_array |
|---|---|
| Buying on Saturday, delivery by XXX, address YYY, payment method ZZZ | {"Buying on Saturday, delivery by XXX, address YYY, payment method ZZZ "} |
| Please quote us on prices and stock availability | {"Please quote us on prices and stock availability"} |
| К52-1Б - 68мкф/50в | {"К52-1Б - 68мкф/50в"} |
| К52-1 - 100мкф/63в | {"К52-1 - 100мкф/63в"} |
SELECT 4