(Good problem, I'm enjoying it - you can give the 200CHF/hr to charity).

I think you can be sure of a good solution when you can model the Circle Line of the London Underground (no first or last stop or any sequence number). Not sure I'm there yet . . . "line-segment" will work but I'm not sure I can avoid infinite loops in the SQL!