sql.extension.rtree.rtree_trigger_insert 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___insert" AFTER INSERT ON ""
WHEN (new."" NOT NULL AND NOT ST_IsEmpty(NEW.""))
BEGIN
INSERT OR REPLACE INTO "rtree__" VALUES (
NEW."",
ST_MinX(NEW.""), ST_MaxX(NEW.""),
ST_MinY(NEW.""), ST_MaxY(NEW."")
);
END;