Then maybe use ST_geometryn to get a single polygon such as select generate_series(1, ST_npoints(geom)-1) as point_id , ST_pointn(ST_exteriorring(ST_geometryn(geom,1)),generate_series(1, ST_npoints(geom)-1)) as geom from polygontable -Eric
----- From: eehab hamzeh [mailto:[email protected]] Sent: Sunday, October 11, 2009 9:33 AM To: Randall, Eric Subject: what if my table contain multipolygon thanks eric for your replay What if my table contain multipolygon how can i adjust the sql statement select generate_series(1, ST_npoints(geom)-1) as point_id , ST_pointn(ST_exteriorring(geom),generate_series(1, ST_npoints(geom)-1)) as geom from polygontable . Kind regards _____ Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail <http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_3:092010> you.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
