thanks a lot
Sufficool, Stanley wrote: > > > 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 > > -- View this message in context: http://www.nabble.com/MULTILINESTRING-edges-tp19633515p19636134.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
