I am working with this query
SELECT ST_MakeLine(route.geom ORDER BY seq) as test FROM (SELECT * FROM pgr_fromAtoB('way',48.24287652969359,33.85220534163203,48.24991464614867,33.85092228417727 )) As routethe above query returns a null cell,I tried
SELECT * FROM pgr_fromAtoB('way',48.24287652969359,33.85220534163203,48.24991464614867,33.85092228417727 )this query works fine and returns a set of columns with a geom (line) and seq columns witch is sequence of parts of lines.
I think I am doing sth wrong with st_makeline but can not find where is it.Can you please help me find the mistake?Does St_makeline works fine with a series of line geometries?
thank you
أكثر...
SELECT ST_MakeLine(route.geom ORDER BY seq) as test FROM (SELECT * FROM pgr_fromAtoB('way',48.24287652969359,33.85220534163203,48.24991464614867,33.85092228417727 )) As routethe above query returns a null cell,I tried
SELECT * FROM pgr_fromAtoB('way',48.24287652969359,33.85220534163203,48.24991464614867,33.85092228417727 )this query works fine and returns a set of columns with a geom (line) and seq columns witch is sequence of parts of lines.
I think I am doing sth wrong with st_makeline but can not find where is it.Can you please help me find the mistake?Does St_makeline works fine with a series of line geometries?
thank you
أكثر...