[postgis-users] point to list

[eehab hamzeh]

Hello 

 

i try to have the points that make one polygon in one table as follow.

 

i have the following polygon

 

polygon (0 0, 0 1, 1 1, 1 0)

 

i need it to be in a table where the results looks like 

 

id :  the_geom

1  :  point(0 0)

2  :  point(0,1)

3  :  point(1 1)

4  :  point(1,0)

 

i try to use st_dump(the geom) from polygon

 

it does not work 

it is important to me to assign id for each point

 

 

thanks 

 
 		 	   		  
_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091011/087e79a1/attachment.html>