[postgis-users] what if my table contain multipolygon

[Randall, Eric]

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:eehab40 at hotmail.com]
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. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091011/7722fbce/attachment.html>