1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| BEGIN
INSERT INTO "test"."Newtable"
SELECT id FROM "test"."Point B"
WHERE EXISTS(SELECT *
FROM "test"."Newtable" AS n
WHERE EXISTS(SELECT *
FROM "test"."TableLigne" AS TL
WHERE st_intersects(TL.geom, n.geom)
AND EXISTS(SELECT * FROM (SELECT * FROM "test"."zone0" AS Z0 WHERE st_intersects(Z0.geom, TL.geom)
UNION ALL
SELECT * FROM "test"."zone1" AS Z1 WHERE st_intersects(Z1.geom, TL.geom)
UNION ALL
SELECT * FROM "test"."zone2" AS Z2 WHERE st_intersects(Z2.geom, TL.geom)) AS ZS)));
RETURN NEW;
END; |
Partager