Skip to content

Instantly share code, notes, and snippets.

@pigreco

pigreco/trigger_WP.sql

Last active August 31, 2018 08:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pigreco/15ffe9a363f17c8781ad6ff0041c7279 to your computer and use it in GitHub Desktop.
Save pigreco/15ffe9a363f17c8781ad6ff0041c7279 to your computer and use it in GitHub Desktop.
Download ZIP
esempio di trigger usato in un geopackage
Raw
trigger_WP.sql
CREATE TRIGGER update_liv3 AFTER INSERT
ON punti_test_trigger
BEGIN
update punti_test_trigger set liv3 =
(select livello3 from CLC where st_within(new.geometry, geom))
WHERE ROWID=NEW.ROWID;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment