[postgis-users] Aggregated Group By and ST_LineMerge

[Elijah Meeks]

I'm using pgRouting to find a shortest path through a network and the result is a set of polylines.  I'd like to combine these polylines into a single geometry using ST_LineMerge.  Coming from MySQL, I was looking for some kind of Group Concat function, but that doesn't seem to be available.  Does anyone have any suggestions?

Thanks,
Elijah

************
Elijah Meeks
http://dhs.stanford.edu
Digital Humanities Specialist
Academic Computing Services
Stanford University
emeeks at stanford.edu
(650)387-6170