[postgis-devel] force output of st_intersection to be point

Rémi Cura remi.cura at gmail.com
Thu Oct 17 09:15:23 PDT 2013


Hey,

quick question :
anybody as an idea about forcing the output of a st_intersection between 2
lines to be a single point and not a line nor a multipoint?

If I use St_PointN or St_First/Last Point? it works on linestring but not
if te output is already a point.

If I use ST_GeometryN the output for linestring is still a linestring, but
it works for multipoint

I don't want to use ST_Dump as it generates many rows.

Any idea??


Cheers,

Rémi-C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20131017/e751cca0/attachment.html>


More information about the postgis-devel mailing list