By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
identifier | point1 | point2 |
---|---|---|
NAME1 | AA1 | BB1 |
NAME2 | AA1 | BB2 |
NAME3 | AA1 | BB3 |
NAME4 | BB2 | CC1 |
NAME5 | BB1 | BB2 |
NAME6 | AA1 | CC1 |
NAME7 | CC1 | BB1 |
NAME8 | BB2 | BB3 |
NAME9 | CC1 | BB3 |
path | path_length |
---|---|
AA1 | 0 |
AA1,CC1,AA1 | 2 |
AA1,BB3,AA1 | 2 |
AA1,BB2,AA1 | 2 |
AA1,BB1,AA1 | 2 |
AA1,CC1,BB2,AA1 | 3 |
AA1,CC1,BB3,AA1 | 3 |
AA1,CC1,BB1,AA1 | 3 |
AA1,BB3,CC1,AA1 | 3 |
AA1,BB3,BB2,AA1 | 3 |
AA1,BB2,BB1,AA1 | 3 |
AA1,BB2,BB3,AA1 | 3 |
AA1,BB2,CC1,AA1 | 3 |
AA1,BB1,CC1,AA1 | 3 |
AA1,BB1,BB2,AA1 | 3 |
AA1,CC1,AA1,CC1,AA1 | 4 |
AA1,CC1,AA1,BB3,AA1 | 4 |
AA1,CC1,AA1,BB2,AA1 | 4 |
AA1,CC1,AA1,BB1,AA1 | 4 |
AA1,CC1,BB2,BB1,AA1 | 4 |
AA1,CC1,BB2,BB3,AA1 | 4 |
AA1,CC1,BB2,CC1,AA1 | 4 |
AA1,CC1,BB3,CC1,AA1 | 4 |
AA1,CC1,BB3,BB2,AA1 | 4 |
AA1,CC1,BB1,CC1,AA1 | 4 |
AA1,CC1,BB1,BB2,AA1 | 4 |
AA1,BB3,CC1,BB2,AA1 | 4 |
AA1,BB3,CC1,BB3,AA1 | 4 |
AA1,BB3,CC1,BB1,AA1 | 4 |
AA1,BB3,BB2,BB1,AA1 | 4 |
AA1,BB3,BB2,BB3,AA1 | 4 |
AA1,BB3,BB2,CC1,AA1 | 4 |
AA1,BB3,AA1,CC1,AA1 | 4 |
AA1,BB3,AA1,BB3,AA1 | 4 |
AA1,BB3,AA1,BB2,AA1 | 4 |
AA1,BB3,AA1,BB1,AA1 | 4 |
AA1,BB2,BB1,CC1,AA1 | 4 |
AA1,BB2,BB1,BB2,AA1 | 4 |
AA1,BB2,AA1,CC1,AA1 | 4 |
AA1,BB2,AA1,BB3,AA1 | 4 |
AA1,BB2,AA1,BB2,AA1 | 4 |
AA1,BB2,AA1,BB1,AA1 | 4 |
AA1,BB2,BB3,CC1,AA1 | 4 |
AA1,BB2,BB3,BB2,AA1 | 4 |
AA1,BB2,CC1,BB2,AA1 | 4 |
AA1,BB2,CC1,BB3,AA1 | 4 |
AA1,BB2,CC1,BB1,AA1 | 4 |
AA1,BB1,CC1,BB2,AA1 | 4 |
AA1,BB1,CC1,BB3,AA1 | 4 |
AA1,BB1,CC1,BB1,AA1 | 4 |
AA1,BB1,AA1,CC1,AA1 | 4 |
AA1,BB1,AA1,BB3,AA1 | 4 |
AA1,BB1,AA1,BB2,AA1 | 4 |
AA1,BB1,AA1,BB1,AA1 | 4 |
AA1,BB1,BB2,BB1,AA1 | 4 |
AA1,BB1,BB2,BB3,AA1 | 4 |
AA1,BB1,BB2,CC1,AA1 | 4 |
AA1,CC1,AA1,CC1,BB2,AA1 | 5 |
AA1,CC1,AA1,CC1,BB3,AA1 | 5 |
AA1,CC1,AA1,CC1,BB1,AA1 | 5 |
AA1,CC1,AA1,BB3,CC1,AA1 | 5 |
AA1,CC1,AA1,BB3,BB2,AA1 | 5 |
AA1,CC1,AA1,BB2,BB1,AA1 | 5 |
AA1,CC1,AA1,BB2,BB3,AA1 | 5 |
AA1,CC1,AA1,BB2,CC1,AA1 | 5 |
AA1,CC1,AA1,BB1,CC1,AA1 | 5 |
AA1,CC1,AA1,BB1,BB2,AA1 | 5 |
AA1,CC1,BB2,BB1,CC1,AA1 | 5 |
AA1,CC1,BB2,BB1,BB2,AA1 | 5 |
AA1,CC1,BB2,AA1,CC1,AA1 | 5 |
AA1,CC1,BB2,AA1,BB3,AA1 | 5 |
AA1,CC1,BB2,AA1,BB2,AA1 | 5 |
AA1,CC1,BB2,AA1,BB1,AA1 | 5 |
AA1,CC1,BB2,BB3,CC1,AA1 | 5 |
AA1,CC1,BB2,BB3,BB2,AA1 | 5 |
AA1,CC1,BB2,CC1,BB2,AA1 | 5 |
AA1,CC1,BB2,CC1,BB3,AA1 | 5 |
AA1,CC1,BB2,CC1,BB1,AA1 | 5 |
AA1,CC1,BB3,CC1,BB2,AA1 | 5 |
AA1,CC1,BB3,CC1,BB3,AA1 | 5 |
AA1,CC1,BB3,CC1,BB1,AA1 | 5 |
AA1,CC1,BB3,BB2,BB1,AA1 | 5 |
AA1,CC1,BB3,BB2,BB3,AA1 | 5 |
AA1,CC1,BB3,BB2,CC1,AA1 | 5 |
AA1,CC1,BB3,AA1,CC1,AA1 | 5 |
AA1,CC1,BB3,AA1,BB3,AA1 | 5 |
AA1,CC1,BB3,AA1,BB2,AA1 | 5 |
AA1,CC1,BB3,AA1,BB1,AA1 | 5 |
AA1,CC1,BB1,CC1,BB2,AA1 | 5 |
AA1,CC1,BB1,CC1,BB3,AA1 | 5 |
AA1,CC1,BB1,CC1,BB1,AA1 | 5 |
AA1,CC1,BB1,AA1,CC1,AA1 | 5 |
AA1,CC1,BB1,AA1,BB3,AA1 | 5 |
AA1,CC1,BB1,AA1,BB2,AA1 | 5 |
AA1,CC1,BB1,AA1,BB1,AA1 | 5 |
AA1,CC1,BB1,BB2,BB1,AA1 | 5 |
AA1,CC1,BB1,BB2,BB3,AA1 | 5 |
AA1,CC1,BB1,BB2,CC1,AA1 | 5 |
AA1,BB3,CC1,AA1,CC1,AA1 | 5 |
AA1,BB3,CC1,AA1,BB3,AA1 | 5 |
AA1,BB3,CC1,AA1,BB2,AA1 | 5 |
AA1,BB3,CC1,AA1,BB1,AA1 | 5 |
AA1,BB3,CC1,BB2,BB1,AA1 | 5 |
AA1,BB3,CC1,BB2,BB3,AA1 | 5 |
AA1,BB3,CC1,BB2,CC1,AA1 | 5 |
AA1,BB3,CC1,BB3,CC1,AA1 | 5 |
AA1,BB3,CC1,BB3,BB2,AA1 | 5 |
AA1,BB3,CC1,BB1,CC1,AA1 | 5 |
AA1,BB3,CC1,BB1,BB2,AA1 | 5 |
AA1,BB3,BB2,BB1,CC1,AA1 | 5 |
AA1,BB3,BB2,BB1,BB2,AA1 | 5 |
AA1,BB3,BB2,AA1,CC1,AA1 | 5 |
AA1,BB3,BB2,AA1,BB3,AA1 | 5 |
AA1,BB3,BB2,AA1,BB2,AA1 | 5 |
AA1,BB3,BB2,AA1,BB1,AA1 | 5 |
AA1,BB3,BB2,BB3,CC1,AA1 | 5 |
AA1,BB3,BB2,BB3,BB2,AA1 | 5 |
AA1,BB3,BB2,CC1,BB2,AA1 | 5 |
AA1,BB3,BB2,CC1,BB3,AA1 | 5 |
AA1,BB3,BB2,CC1,BB1,AA1 | 5 |
AA1,BB3,AA1,CC1,BB2,AA1 | 5 |
AA1,BB3,AA1,CC1,BB3,AA1 | 5 |
AA1,BB3,AA1,CC1,BB1,AA1 | 5 |
AA1,BB3,AA1,BB3,CC1,AA1 | 5 |
AA1,BB3,AA1,BB3,BB2,AA1 | 5 |
AA1,BB3,AA1,BB2,BB1,AA1 | 5 |
AA1,BB3,AA1,BB2,BB3,AA1 | 5 |
AA1,BB3,AA1,BB2,CC1,AA1 | 5 |
AA1,BB3,AA1,BB1,CC1,AA1 | 5 |
AA1,BB3,AA1,BB1,BB2,AA1 | 5 |
AA1,BB2,BB1,CC1,BB2,AA1 | 5 |
AA1,BB2,BB1,CC1,BB3,AA1 | 5 |
AA1,BB2,BB1,CC1,BB1,AA1 | 5 |
AA1,BB2,BB1,AA1,CC1,AA1 | 5 |
AA1,BB2,BB1,AA1,BB3,AA1 | 5 |
AA1,BB2,BB1,AA1,BB2,AA1 | 5 |
AA1,BB2,BB1,AA1,BB1,AA1 | 5 |
AA1,BB2,BB1,BB2,BB1,AA1 | 5 |
AA1,BB2,BB1,BB2,BB3,AA1 | 5 |
AA1,BB2,BB1,BB2,CC1,AA1 | 5 |
AA1,BB2,AA1,CC1,BB2,AA1 | 5 |
AA1,BB2,AA1,CC1,BB3,AA1 | 5 |
AA1,BB2,AA1,CC1,BB1,AA1 | 5 |
AA1,BB2,AA1,BB3,CC1,AA1 | 5 |
AA1,BB2,AA1,BB3,BB2,AA1 | 5 |
AA1,BB2,AA1,BB2,BB1,AA1 | 5 |
AA1,BB2,AA1,BB2,BB3,AA1 | 5 |
AA1,BB2,AA1,BB2,CC1,AA1 | 5 |
AA1,BB2,AA1,BB1,CC1,AA1 | 5 |
AA1,BB2,AA1,BB1,BB2,AA1 | 5 |
AA1,BB2,BB3,CC1,BB2,AA1 | 5 |
AA1,BB2,BB3,CC1,BB3,AA1 | 5 |
AA1,BB2,BB3,CC1,BB1,AA1 | 5 |
AA1,BB2,BB3,BB2,BB1,AA1 | 5 |
AA1,BB2,BB3,BB2,BB3,AA1 | 5 |
AA1,BB2,BB3,BB2,CC1,AA1 | 5 |
AA1,BB2,BB3,AA1,CC1,AA1 | 5 |
AA1,BB2,BB3,AA1,BB3,AA1 | 5 |
AA1,BB2,BB3,AA1,BB2,AA1 | 5 |
AA1,BB2,BB3,AA1,BB1,AA1 | 5 |
AA1,BB2,CC1,AA1,CC1,AA1 | 5 |
AA1,BB2,CC1,AA1,BB3,AA1 | 5 |
AA1,BB2,CC1,AA1,BB2,AA1 | 5 |
AA1,BB2,CC1,AA1,BB1,AA1 | 5 |
AA1,BB2,CC1,BB2,BB1,AA1 | 5 |
AA1,BB2,CC1,BB2,BB3,AA1 | 5 |
AA1,BB2,CC1,BB2,CC1,AA1 | 5 |
AA1,BB2,CC1,BB3,CC1,AA1 | 5 |
AA1,BB2,CC1,BB3,BB2,AA1 | 5 |
AA1,BB2,CC1,BB1,CC1,AA1 | 5 |
AA1,BB2,CC1,BB1,BB2,AA1 | 5 |
AA1,BB1,CC1,AA1,CC1,AA1 | 5 |
AA1,BB1,CC1,AA1,BB3,AA1 | 5 |
AA1,BB1,CC1,AA1,BB2,AA1 | 5 |
AA1,BB1,CC1,AA1,BB1,AA1 | 5 |
AA1,BB1,CC1,BB2,BB1,AA1 | 5 |
AA1,BB1,CC1,BB2,BB3,AA1 | 5 |
AA1,BB1,CC1,BB2,CC1,AA1 | 5 |
AA1,BB1,CC1,BB3,CC1,AA1 | 5 |
AA1,BB1,CC1,BB3,BB2,AA1 | 5 |
AA1,BB1,CC1,BB1,CC1,AA1 | 5 |
AA1,BB1,CC1,BB1,BB2,AA1 | 5 |
AA1,BB1,AA1,CC1,BB2,AA1 | 5 |
AA1,BB1,AA1,CC1,BB3,AA1 | 5 |
AA1,BB1,AA1,CC1,BB1,AA1 | 5 |
AA1,BB1,AA1,BB3,CC1,AA1 | 5 |
AA1,BB1,AA1,BB3,BB2,AA1 | 5 |
AA1,BB1,AA1,BB2,BB1,AA1 | 5 |
AA1,BB1,AA1,BB2,BB3,AA1 | 5 |
AA1,BB1,AA1,BB2,CC1,AA1 | 5 |
AA1,BB1,AA1,BB1,CC1,AA1 | 5 |
AA1,BB1,AA1,BB1,BB2,AA1 | 5 |
AA1,BB1,BB2,BB1,CC1,AA1 | 5 |
AA1,BB1,BB2,BB1,BB2,AA1 | 5 |
AA1,BB1,BB2,AA1,CC1,AA1 | 5 |
AA1,BB1,BB2,AA1,BB3,AA1 | 5 |
AA1,BB1,BB2,AA1,BB2,AA1 | 5 |
AA1,BB1,BB2,AA1,BB1,AA1 | 5 |
AA1,BB1,BB2,BB3,CC1,AA1 | 5 |
AA1,BB1,BB2,BB3,BB2,AA1 | 5 |
AA1,BB1,BB2,CC1,BB2,AA1 | 5 |
AA1,BB1,BB2,CC1,BB3,AA1 | 5 |
AA1,BB1,BB2,CC1,BB1,AA1 | 5 |