[postgis-users] create holes in ocean polygons with island polygons

[paul.malm at lfv.se]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190820/f5a20cf4/attachment.html>