[postgis-users] get segment of multiline between two points

[Marco]

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: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Marco
> Sent: Friday, September 10, 2010 1:15 PM
> To: postgis-users at postgis.refractions.net
> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>