[postgis-users] MULTILINESTRING edges

[Sufficool, Stanley]

Or try a real query (smacks head):

select st_pointn(the_geom, 1) as first_point, st_pointn(the_geom,
st_npoints(the_geom)) as last_point From my_geometry_table




> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Sufficool, Stanley
> Sent: Tuesday, September 23, 2008 12:27 PM
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] MULTILINESTRING edges
> 
> 
> Try:
> 
> select st_pointn(the_geom) as first_point,
> st_pointn(st_npoints(the_geom)) as last_point
> >From my_geometry_table
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On 
> > Behalf Of Nandorov
> > Sent: Tuesday, September 23, 2008 11:03 AM
> > To: postgis-users at postgis.refractions.net
> > Subject: [postgis-users] MULTILINESTRING edges
> > 
> > 
> > 
> > hi again, i'm sorry if i bother you, but i need some help
> > 
> > I have a multilinestring, and i want to get the coordinates
> > of its edges. For example i have MULTILINESTRING(0 1, 2 3, 6 
> > 7,4 6) i want to recover its edges that would be 
> > (0 1) and (4 6)
> > X & Y function only works with points, if there's a function 
> > to get them? or i have to build my own?
> > 
> > thanks
> > --
> > View this message in context: 
> > http://www.nabble.com/MULTILINESTRING-edges-tp19633515p19633515.html
> > Sent from the PostGIS - User mailing list archive at Nabble.com.
> > 
> > _______________________________________________
> > 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
>