[postgis-users] MULTILINESTRING edges

[Sufficool, Stanley]

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
>