By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| id | value | path |
|---|---|---|
| 1 | a1 | a1 |
| 2 | b2 | a1->b2 |
| 3 | c3 | a1->b2->c3 |
| 4 | d4 | a1->b2->c3->d4 |
| 5 | e5 | a1->b2->c3->d4->e5 |
| 6 | f6 | a1->b2->c3->d4->e5->f6 |
| 7 | g7 | a1->b2->c3->d4->e5->f6->g7 |
| 8 | h8 | a1->b2->c3->d4->e5->f6->g7->h8 |