By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| color | path |
|---|---|
| blue | {H} |
| blue | {I,J} |
| green | {A,B,C,D} |
| red | {E,F,G} |
10 rows affected
| color | path |
|---|---|
| blue | {H} |
| blue | {I,J} |
| green | {A,B,C,D} |
| red | {E,F,G} |