[pgrouting-users] problem with query results

[Valeria Muñoz]

Hi

 I have problems with the query results, The results are not sorted.

my Query:

SELECT rt.gid,rt.the_geom AS tg, AsText(rt.the_geom) AS wkt,
length(rt.the_geom) AS length, calle.gid FROM calle, (SELECT gid, the_geom
FROM dijkstra_sp_delta( 'calle', 3429, 3406, 3000) ) as rt WHERE
calle.gid=rt.gid;

result:
"gid";"tg";"wkt";"length";"gid"
*4416*;"0105000020B30F00000100000001020000000200000018E60A2187CC51C007069A16AD973EC0AA2CA7847ECC51C0EB933A5AA9973EC0";"MULTILINESTRING((-71.1957476240572
-30.5924848676714,-71.1952220566333
-30.5924278634083))";0.000528649792432027;4416
*4414*;"0105000020B30F000001000000010200000002000000F9E3B4109BCC51C065E35F65B5973EC0656B43BC8ECC51C02D2D6B65B0973EC0";"MULTILINESTRING((-71.1969644323834
-30.5926116332152,-71.1962118776697
-30.5925353418981))";0.000756411899864822;4414
*4415*;"0105000020B30F000001000000010200000002000000656B43BC8ECC51C02D2D6B65B0973EC018E60A2187CC51C007069A16AD973EC0";"MULTILINESTRING((-71.1962118776697
-30.5925353418981,-71.1957476240572
-30.5924848676714))";0.00046698936208239;4415
*4417*;"0105000020B30F000001000000010200000002000000AA2CA7847ECC51C0EB933A5AA9973EC04DFDF22B7ACC51C0FD7FB373A7973EC0";"MULTILINESTRING((-71.1952220566333
-30.5924278634083,-71.194956767363
-30.5923988641007))";0.000266869550146504;4417
 should be given A, B and C gave me B, A and C, then I can not generate a
guide of how to get from point A to B properly..

 Can sort the results?..please help..
RG
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20090204/6bc6d0f0/attachment.html