Hi, I have a table with ocean polygons and would like to create holes in those polygons with an island layer (including island polygons). I've tried this:
UPDATE public."Ocean" SET the_geom = ST_Multi(ST_Difference("Ocean".the_geom, b.the_geom)) FROM "Islands" as b WHERE ST_Intersects( "Ocean ".the_geom, b.the_geom) Postgresql reports 5 uppdates. But there are no holes in the ocean polygons, in the location of the islands. What are I'm doing wrong? Kind regards, Paul
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users