postgresql 把几列的数据合并为一列?
现有如下数据:
sroadid id geom
"4L4552";337671;"POINT(120.24588 31.50656)"
"4L4552";337672;"POINT(120.245696625233 31.506692654087)"
"4L4552";337673;"POINT(120.245513250465 31.506825308174)"
"4L4552";337674;"POINT(120.245340073154 31.5069699268456)"
"4L4552";337675;"POINT(120.245180036577 31.5071299634228)"
"4L4552";337676;"POINT(120.24502 31.50729)"
"5L30394";337677;"POINT(120.22481 31.68237)"
"5L30394";337678;"POINT(120.224603162589 31.6823602664747)"
"5L30394";337679;"POINT(120.224396325177 31.6823505329495)"
"5L30394";337680;"POINT(120.224189487765 31.6823407994242)"
"5L30394";337681;"POINT(120.223982650354 31.682331065899)"
"5L30394";337682;"POINT(120.22378 31.68229)"
"5L5511";337683;"POINT(120.36083 31.51451)"
"5L5511";337684;"POINT(120.360941252689 31.5147914038613)"
如何通过sql语句变为如下数据:
sroadid geoms
4L4552 POINT(120.24588 31.50656)...POINT(120.24502 31.50729)
5L30394 POINT(120.22481 31.68237)...POINT(120.22378 31.68229)
...
geoms中point要按id顺序排列相组合。
我用了group by 但是geom没有按顺序添加到geoms中。