Thanks Paolo
It worked like this:
set geom_simply=ST_Multi(ST_SimplifyPreserveTopology(geom, 100))
Bie
Pietro
2013/8/12 Paolo Cavallini
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Il 12/08/2013 13:19, Pietro Rossin ha scritto:
>
> > UPDATE mytable SET
> > geom_simply=ST_SimplifyPreser
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Il 12/08/2013 13:19, Pietro Rossin ha scritto:
> UPDATE mytable SET
> geom_simply=ST_SimplifyPreserveTopology(st_multi(geom), 100)
>
> ERROR: Geometry type (Polygon) does not match column type
> (MultiPolygon) SQL state: 22023
>
> Why?
Try
SET
Hello
I'm trying to copy polygons from one column to another to reduce vertex
numbers
my columns are geom (geom geometry(MultiPolygonZ,3004))
and geom_simply (geom_simply geometry(MultiPolygonZ,3004))
With this query
UPDATE mytable
SET geom_simply=ST_SimplifyPreserveTopology(geom, 100)
I get th
