• Home
• mil.nga.geopackage
• geopackage-core
• 6.6.4
• source code
• rtree_trigger_insert

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.extension.rtree.rtree_trigger_insert Maven / Gradle / Ivy

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;