By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| VALUE | IDX | ITEM |
|---|---|---|
| \ | 1 | null |
| \ | 2 | null |
| abc\def\ghi\jkl | 1 | abc |
| abc\def\ghi\jkl | 2 | def |
| abc\def\ghi\jkl | 3 | null |
| abc\def\ghi\jkl | 4 | ghi |
| abc\def\ghi\jkl | 5 | jkl |
| null | 1 | null |