<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Hi Hugues,</div>
<div> </div>
<div>i try it like:</div>
<div> </div>
<div>WITH flstfinal AS (flstfinal)<br/>
SELECT (st_dumppoints).path, (st_dumppoints).geom FROM flstfinal</div>
<div> </div>
<div>and i have this mistake:</div>
<div> </div>
<div>
<div>FEHLER: Syntaxfehler bei „flstfinal“<br/>
LINE 1: WITH flstfinal AS (flstfinal)<br/>
^<br/>
********** Fehler **********</div>
<div>FEHLER: Syntaxfehler bei „flstfinal“<br/>
SQL Status:42601<br/>
Zeichen:20</div>
<div> </div>
<div>Where is my fault?</div>
</div>
<div>
<div name="quote" style="margin: 10px 5px 5px 10px; padding: 10px 0px 10px 10px; border-left-color: rgb(195, 217, 229); border-left-width: 2px; border-left-style: solid; -ms-word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin: 0px 0px 10px;"><b>Gesendet:</b> Freitag, 05. August 2016 um 09:20 Uhr<br/>
<b>Von:</b> "Hugues François" <hugues.francois@irstea.fr><br/>
<b>An:</b> "PostGIS Users Discussion" <postgis-users@lists.osgeo.org><br/>
<b>Betreff:</b> Re: [postgis-users] Problem with st_dumppoints</div>
<div name="quoted-content">
<p>Hi,</p>
<p>If I understand what you're looking for, I think you just need to call path and geom separately. This would look like:<br/>
WITH yourquery AS (yourquery)<br/>
SELECT (st_dumppoints).path, (st_dumppoints).geom FROM yourquery</p>
<p>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).</p>
<p>HTH</p>
<p>Hug</p>
<div class="gmail_extra">
<div class="gmail_quote">Le 5 août 2016 8:56 AM, Sebastian Teßmer <SebastianTessmer@gmx.de> a écrit :
<blockquote class="quote" style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;">
<div>
<div style="font-family: verdana; font-size: 12px;">
<div>Hi everybody,</div>
<div> </div>
<div>i have a problem with st_dumppoints and i hope you can help...</div>
<div> </div>
<div>my sql is:</div>
<div> </div>
<div><strong>SELECT st_dumppoints(st_transform(flstfinal.geom, 4326)) AS st_dumppoints FROM flstfinal;</strong></div>
<div> </div>
<div>with the result (for example):</div>
<div> </div>
<div><strong>("{1,1,1}", and then a wkt geometry.....</strong></div>
<div> </div>
<div>at the beginning, i have that i want, but the geomtery isn't that what i want.</div>
<div> </div>
<div>I need a geometry like <strong>MULTIPOINT(.....)</strong></div>
<div> </div>
<div>I want a result like:</div>
<div> </div>
<div><u>Column 1 | Column 2</u></div>
<div>1,1,1 | Multipoint(Point in WGS84)</div>
<div>....</div>
<div>Can anybody help me?</div>
<div> </div>
<div>Thank you very munch!!!</div>
<div> </div>
<div>Sebastian</div>
<div> </div>
<div> </div>
</div>
</div>
</blockquote>
</div>
</div>
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org <a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</div>
</div>
</div></div></body></html>