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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Nandorov > Sent: Tuesday, September 23, 2008 11:03 AM > To: [email protected] > 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 [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
