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 mytable AS (
SELECT 'TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3' as mystring
)
SELECT
*
FROM mytable
| mystring |
|---|
| TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3 |
WITH mytable AS (
SELECT 'TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3' as mystring
)
SELECT
*
FROM mytable,
regexp_split_to_table(mystring, '\|') as elements
| mystring | elements |
|---|---|
| TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3 | TType=SEND |
| TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3 | Status=OK |
| TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3 | URL=min://j?_a=3&ver=1.1 |
| TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3 | day=3 |
WITH mytable AS (
SELECT 'TType=SEND|Status=OK|URL=min://j?_a=3&ver=1.1|day=3' as mystring
)
SELECT
string_agg(elements,'|')
FROM mytable,
regexp_split_to_table(mystring, '\|') as elements
WHERE split_part(elements, '=', 1) = ANY(ARRAY['TType', 'URL']) IS NOT TRUE
| string_agg |
|---|
| Status=OK|day=3 |