sql.extension.rtree.rtree_trigger_update1 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

Core functionality for GeoPackage implementations

There is a newer version: 6.6.7

CREATE TRIGGER "rtree___update1" AFTER UPDATE OF "" ON ""
  WHEN OLD."" = NEW."" AND
       (NEW."" NOTNULL 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;