Thanks Maxime! On May 10, 2010, at 11:47 AM, Maxime van Noppen wrote:
> On 05/10/2010 05:32 PM, Charles Galpin wrote: >> I searched the archives and saw this asked in 2005 but it didn't appear to >> have a resolution then. I have two points in a multipoint geometry which >> represent the start and end point of road segments that I need to extract >> the points back out of, but ST_PointN doesn't work for multipoints, nor can >> I convert the multipoint to a linestring with ST_MakeLine and use ST_PointN >> then on the resultant line (because it doesn't work on multipoint geometries >> either). >> >> Does anyone know a way to do this? > > Hi, > > You can use the ST_Dump function. > > http://postgis.refractions.net/docs/ST_Dump.html > > -- > Maxime _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users