• Home
• mil.nga.geopackage
• geopackage-core
• 6.6.7
• source code
• rtree_trigger_update6

×

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_update6 Maven / Gradle / Ivy

CREATE TRIGGER "rtree___update6" AFTER UPDATE OF "" ON ""
  WHEN OLD."" = NEW."" AND
       (NEW."" NOTNULL AND NOT ST_IsEmpty(NEW."")) AND
       (OLD."" NOTNULL AND NOT ST_IsEmpty(OLD.""))
BEGIN
  UPDATE "rtree__" SET
    minx = ST_MinX(NEW.""),
    maxx = ST_MaxX(NEW.""),
    miny = ST_MinY(NEW.""),
    maxy = ST_MaxY(NEW."")
  WHERE id = NEW."";
END;