<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1255">
<STYLE>.hmmessage P {
PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-SIZE: 10pt; FONT-FAMILY: Verdana
}
</STYLE>
<META content="MSHTML 6.00.6001.18248" name=GENERATOR></HEAD>
<BODY class=hmmessage>
<DIV><FONT face=Arial color=#0000ff> </FONT>
<DIV><SPAN class=214203414-11102009><FONT face=Arial color=#0000ff>Then maybe
use ST_geometryn to get a single polygon such as</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff>select generate_series(1,
ST_npoints(geom)-1) as point_id , ST_pointn(ST_exteriorring(<SPAN
class=214203414-11102009>ST_geometryn(</SPAN>geom<SPAN
class=214203414-11102009>,1</SPAN>)<SPAN
class=214203414-11102009>)</SPAN>,generate_series(1, ST_npoints(geom)-1)) as
geom from polygontable</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<DIV><SPAN class=910105114-11102009><FONT face=Arial
color=#0000ff>-Eric</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV></DIV>
<DIV> </DIV>
<P><FONT face=Tahoma>-----<BR><B>From:</B> eehab hamzeh
[mailto:eehab40@hotmail.com]<BR><B>Sent:</B> Sunday, October 11, 2009 9:33
AM<BR><B>To:</B> Randall, Eric<BR><B>Subject:</B> what if my table contain
multipolygon<BR><BR></FONT></P>
<BLOCKQUOTE>thanks eric for your replay<BR><BR>What if my table contain
multipolygon <BR>how can i adjust the sql statement<BR><BR>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 .<BR><BR>Kind regards<BR><BR><BR><BR><IMG alt=""
NOSEND="1"><IMG alt="" NOSEND="1"><IMG alt="" NOSEND="1"><BR><BR><BR>
<HR>
Windows Live: <A
href="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"
target=_new>Friends get your Flickr, Yelp, and Digg updates when they e-mail
you.</A> </BLOCKQUOTE></BODY></HTML>