[postgis-users] create a single multilinestring field from a column of linestring
raffaellobertini at gmail.com
Mon Nov 26 07:56:54 PST 2012
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
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...
More information about the postgis-users