<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hello <br><br>I have the following table which has polygons, i need to create a multipolygon from these polygons<br>i tried to use the following query, but the result are strange<br><br>331;"POLYGON((-14161.75 2241.76 2600,-14161.75 2241.76 2900,-14161.75 1941.76 2900,-14161.75 1941.76 2600,-14161.75 2241.76 2600))"<br>338;"POLYGON((-9336.75 2241.76 2600,-9336.75 2241.76 2900,-9336.75 1941.76 2900,-9336.75 1941.76 2600,-9336.75 2241.76 2600))"<br>341;"POLYGON((-14161.75 1941.76 2600,-14161.75 2241.76 2600,-9336.75 2241.76 2600,-9336.75 1941.76 2600,-14161.75 1941.76 2600))"<br>344;"POLYGON((-14161.75 1941.76 2900,-14161.75 1941.76 2600,-9336.75 1941.76 2600,-9336.75 1941.76 2900,-14161.75 1941.76 2900))"<br>347;"POLYGON((-14161.75 2241.76 2900,-14161.75 1941.76 2900,-9336.75 1941.76 2900,-9336.75 2241.76 2900,-14161.75 2241.76 2900))"<br>350;"POLYGON((-14161.75 2241.76 2600,-14161.75 2241.76 2900,-9336.75 2241.76 2900,-9336.75 2241.76 2600,-14161.75 2241.76 2600))"<br>331;"POLYGON((-14161.75 2241.76 2600,-14161.75 2241.76 2900,-14161.75 1941.76 2900,-14161.75 1941.76 2600,-14161.75 2241.76 2600))"<br><br>SELECT asEwkt(ST_Multi(ST_Union(ARRAY(SELECT the_geom FROM faces_obj))));<br><br>the result<br><br>"MULTIPOLYGON(((-14161.75 1941.76 2750,-14161.75 2241.76 2750,-9336.75 2241.76 2600,-9336.75 1941.76 2750,-14161.75 1941.76 2600)))"<br><br>Kind regards<br><br>Ihab <br><br> <br /><hr />See all the ways you can stay connected <a href='http://www.microsoft.com/windows/windowslive/default.aspx' target='_new'>to friends and family</a></body>
</html>