I use PostGis and pgRouting. I have a table with geometries of the adjacent edges returned by a shortest path query. I want to concatenate these edges and retrieve a list of all nodes these edges consist of. How do I do this in SQL?
I think the solution would be a mix of LineMerge and GeomUnion, but is there a smart way to do it?