<div dir="ltr">Thanks Paolo<div style>It worked like this:</div><div style>set geom_simply=ST_Multi(ST_SimplifyPreserveTopology(geom, 100))<br></div><div style>Bie</div><div style>Pietro</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2013/8/12 Paolo Cavallini <span dir="ltr"><<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
Il 12/08/2013 13:19, Pietro Rossin ha scritto:<br>
<br>
> UPDATE mytable SET<br>
> geom_simply=ST_SimplifyPreserveTopology(st_multi(geom), 100)<br>
><br>
> ERROR: Geometry type (Polygon) does not match column type<br>
> (MultiPolygon) SQL state: 22023<br>
><br>
> Why?<br>
<br>
Try<br>
    SET<br>
geom_simply=ST_Multi(ST_SimplifyPreserveTopology(st_multi(geom), 100))<br>
<br>
- --<br>
Paolo Cavallini - Faunalia<br>
<a href="http://www.faunalia.eu" target="_blank">www.faunalia.eu</a><br>
Full contact details at <a href="http://www.faunalia.eu/pc" target="_blank">www.faunalia.eu/pc</a><br>
Nuovi corsi QGIS e PostGIS: <a href="http://www.faunalia.it/calendario" target="_blank">http://www.faunalia.it/calendario</a><br>
-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1.4.14 (GNU/Linux)<br>
Comment: Using GnuPG with Mozilla - <a href="http://enigmail.mozdev.org/" target="_blank">http://enigmail.mozdev.org/</a><br>
<br>
iEYEARECAAYFAlIIx1UACgkQ/NedwLUzIr7CfgCgmrjYsZx1VYPv8e1s84xKJ61Q<br>
wu0An1uGZgFQF5mvhfj98flwerRC3KTj<br>
=dUaB<br>
-----END PGP SIGNATURE-----<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div>