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

Reply via email to