By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
26 rows affected
| Pos | Child | Parent | Test | lvl | path |
|---|---|---|---|---|---|
| 1 | A | null | 1 | 1 | A |
| 1 | B | A | 2 | 2 | A/B |
| 1 | C | B | 3 | 3 | A/B/C |
| 2 | D | B | 4 | 3 | A/B/D |
| 2 | E | A | 5 | 2 | A/E |
| 1 | F | E | 6 | 3 | A/E/F |
| 2 | G | E | 7 | 3 | A/E/G |
| 1 | H | G | 8 | 4 | A/E/G/H |
| 2 | I | G | 9 | 4 | A/E/G/I |
| 2 | J | null | 10 | 1 | J |
| 1 | K | J | 11 | 2 | J/K |
| 2 | L | J | 12 | 2 | J/L |
| 3 | M | J | 13 | 2 | J/M |
| 1 | N | M | 14 | 3 | J/M/N |
| 2 | O | M | 15 | 3 | J/M/O |
| 3 | P | null | 16 | 1 | P |
| 1 | Q | P | 17 | 2 | P/Q |
| 1 | R | Q | 18 | 3 | P/Q/R |
| 2 | S | P | 19 | 2 | P/S |
| 3 | T | P | 20 | 2 | P/T |
| 1 | U | T | 21 | 3 | P/T/U |
| 2 | V | T | 22 | 3 | P/T/V |
| 3 | W | T | 23 | 3 | P/T/W |
| 4 | X | P | 24 | 2 | P/X |
| 4 | Y | null | 25 | 1 | Y |
| 5 | Z | null | 26 | 1 | Z |