By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 17
| edgeid | fromnodeid | tonodeid | edgetype | edgelength | edgepatharray |
|---|---|---|---|---|---|
| 8 | 2 | 3 | 2 | 25 | {1,2,3,7,8} |
| 4 | 5 | 4 | 3 | 15 | {4} |
| 3 | 4 | 3 | 2 | 40 | {6,7,8,2,3} |
| 12 | 7 | 9 | 2 | 10 | {9,10,11,12} |
| 13 | 10 | 9 | 2 | 10 | {9,10,11,13} |
| 16 | 14 | 13 | 2 | 25 | {15,16} |
SELECT 6