Thanks, I tried this function, but it returns all points and I need only that
are inside a segment between two points.

ie:

MULTILINESTRING((0 0,1 1,1 2,2 3,3 2,5 4))
POINT(1 1) POINT(3 2)

I want LINESTRING(1 1,1 2,2 3,3 2)


Il 10/09/10 19.48, Paragon Corporation ha scritto:
Marco,

Yes.

If you are using PostGIS 1.5 or above you can use ST_DumpPoints to dump the
points out which is a bit faster than ST_PointN (or you can use ST_Point)

http://www.postgis.org/documentation/manual-svn/ST_DumpPoints.html

For lower versions you can use ST_PointN

http://www.postgis.org/documentation/manual-svn/ST_PointN.html

Leo and Regina
http://www.postgis.us



-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Marco
Sent: Friday, September 10, 2010 1:15 PM
To: [email protected]
Subject: [postgis-users] get segment of multiline between two points

Hi,

as the subject I've two points on a layer multiline and I need all the
points included in that segment to draw on the client side.

is this possible?
thanks
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to