<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
<br><pre>When I do this (notice the second ST_COLLECT):<br>select ST_AsEWKT (ST_COLLECT (geom)) from (<br> select (ST_DUMP(geom)).geom from (select p_geom as geom from (<br> select ST_COLLECT (geom_col, st_GeomFromEWKT('Point(1 -1 0 10)')) as<br>p_geom from tab) a<br> )as b ) as c<br>I get:<br> "MULTIPOINT(71.1 -42.31 10 10,1 -1 0 10,1 -1 0 10)"<br>This is fine, except that "1 -1 0 10" gets repeated.<br> <br>BUT---<br>When I do (I use ST_UNION here):<br>select ST_AsEWKT (ST_COLLECT (geom)) from (<br> select (ST_DUMP(geom)).geom from (select p_geom as geom from (<br> select ST_UNION (geom_col, st_GeomFromEWKT('Point(1 -1 0 10)')) as p_geom<br>from tab) a<br> )as b ) as c<br>I get this:<br> "MULTIPOINT(1 -1 0,71.1 -42.31 10)"<br>No repetition, but the M coordinate is missing.<br> <br>Any pointers on what's going wrong here?<br><br></pre><br /><hr />Are you an untamed, bizarre or daring explorer? Find out now! <a href='http://www.ExploreMyWay.com' target='_new'>Drag n' drop</a></body>
</html>