[postgis-users] create a single multilinestring field from a column of linestring

[Raffaello Bertini]

Hi there,
I need to create a field multilinestring / linestring, where the values are
taken from a column of linestring

I need a result that consist in only one row and one col.
here my snipett sql:

SELECT ST_AsText(ST_Multi(ST_Collect(geom_way))) as singlegeom
 FROM emily_route
group by id

but there are many rows as the table itself. and i don't know even if the
'singlegeom' is the
"array of the all the geometry in the emili_route table".

If i remove the group by the results is an empty table 1x1 (only the table
dimension is right:))

any helps please?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121126/9517b66f/attachment.html>