By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 9 Duplicates: 0 Warnings: 0
| col1 | col2 | rn |
|---|---|---|
| 113 | 765 | 1 |
| 122 | 881 | 2 |
| 300 | 400 | 3 |
| 765 | 765 | 4 |
| 765 | 910 | 5 |
| 881 | 113 | 6 |
| 910 | 345 | 7 |
| 988 | 899 | 8 |
| 999 | 988 | 9 |
| lvl | rn | col1 | col2 | next | path |
|---|---|---|---|---|---|
| 2 | 1 | 113 | 765 | 345 | :1:4:5:7 |
| 4 | 2 | 122 | 881 | 345 | :2:6:1:4:5:7 |
| 0 | 3 | 300 | 400 | null | null |
| 1 | 4 | 765 | 765 | 345 | :4:5:7 |
| 0 | 5 | 765 | 910 | 345 | :5:7 |
| 3 | 6 | 881 | 113 | 345 | :6:1:4:5:7 |
| 0 | 7 | 910 | 345 | null | null |
| 0 | 8 | 988 | 899 | null | null |
| 0 | 9 | 999 | 988 | 899 | :9:8 |
Table 'fiddle.r' doesn't exist