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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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: [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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
