Hi,
If I understand what you're looking for, I think you just need to call path and geom separately. This would look like:
WITH yourquery AS (yourquery)
SELECT (st_dumppoints).path, (st_dumppoints).geom FROM yourquery
And if you want to collect all points of an object you could do that using a group by clause on the object identifier and st_collect((st_dumppoints).geom).
HTH
Hug
Le 5 août 2016 8:56 AM, Sebastian Teßmer <[email protected]> a écrit :
Hi everybody,i have a problem with st_dumppoints and i hope you can help...my sql is:SELECT st_dumppoints(st_transform(flstfinal.geom, 4326)) AS st_dumppoints FROM flstfinal;with the result (for example):("{1,1,1}", and then a wkt geometry.....at the beginning, i have that i want, but the geomtery isn't that what i want.I need a geometry like MULTIPOINT(.....)I want a result like:Column 1 | Column 21,1,1 | Multipoint(Point in WGS84)....Can anybody help me?Thank you very munch!!!Sebastian
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
