<!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><SPAN
class=901300813-11102009>Try,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff>select generate_series(1, <SPAN
class=901300813-11102009>ST_</SPAN>npoints(geom)-1)<SPAN
class=901300813-11102009> as point_id </SPAN>, ST_pointn(<SPAN
class=901300813-11102009>ST</SPAN>_exteriorring(geom),generate_series(1, <SPAN
class=901300813-11102009>ST_</SPAN>npoints(geom)-1))<SPAN
class=901300813-11102009> as geom</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN class=901300813-11102009>from
polygontable</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=901300813-11102009></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=901300813-11102009></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=901300813-11102009></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN class=901300813-11102009>based
on this post <A
href="http://www.nabble.com/Re:-Splitting-linestring-into-line-segments-td16063883.html">http://www.nabble.com/Re:-Splitting-linestring-into-line-segments-td16063883.html</A></SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=901300813-11102009></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=901300813-11102009></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=901300813-11102009>-Eric</SPAN></FONT></FONT></DIV>
<P><FONT face=Arial color=#0000ff></FONT> </P>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>On Behalf Of
</B>eehab hamzeh<BR><B>Sent:</B> Sunday, October 11, 2009 8:13
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] point to list<BR><BR></FONT></DIV>Hello <BR> <BR>i try to
have the points that make one polygon in one table as follow.<BR> <BR>i
have the following polygon<BR> <BR>polygon (0 0, 0 1, 1 1, 1
0)<BR> <BR>i need it to be in a table where the results looks like
<BR> <BR>id : the_geom<BR>1 : point(0
0)<BR>2 : point(0,1)<BR>3 : point(1 1)<BR>4
: point(1,0)<BR> <BR>i try to use st_dump(the geom) from
polygon<BR> <BR>it does not work <BR>it is important to me to assign id
for each point<BR> <BR> <BR>thanks <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>