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

[Rémi Cura]

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>