developer (#13) - Shortest path sequence. (#257) - Message List

Shortest path sequence.

The reply for ticket #106 (closed feature request: fixed) says: "Done - id field added to the output type. Being sorted by id result becomes ordered." But when I execute

"SELECT * FROM dijkstra_sp('road_network',4352,4052)" ,

the query returns a result set containing id,gid and the_geom. But the id is in the order of the gid which even after sorting returns the same result set. When I use these query to find the direction I get messed up with the order of the Linestrings retrieved from the_geom column since it is not in the order. How can I retrieve the lines in the order. (The id column generated along with this query I guess is just a enumerated value which will not help me out to find the direction.). Can u please explain how the id is generated for "dijkstra_sp()".

Thanks in advance for your reply