sql.extension.rtree.rtree_trigger_update4 Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of geopackage-core Show documentation
Show all versions of geopackage-core Show documentation
Core functionality for GeoPackage implementations
The newest version!
CREATE TRIGGER "rtree___update4" AFTER UPDATE ON ""
WHEN OLD."" != NEW."" AND
(NEW."" ISNULL OR ST_IsEmpty(NEW.""))
BEGIN
DELETE FROM "rtree__" WHERE id IN (OLD."", NEW."");
END;