Skip to content

Instantly share code, notes, and snippets.

@Breefield

Breefield/trigger.sql

Created November 16, 2020 22:18
Show Gist options
  • Save Breefield/8c16ffe9a840fdf23171db5b92d0d347 to your computer and use it in GitHub Desktop.
Save Breefield/8c16ffe9a840fdf23171db5b92d0d347 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
trigger.sql
CREATE TRIGGER test_trigger_insert_update AFTER UPDATE OR INSERT ON inventory FOR EACH ROW EXECUTE PROCEDURE record_inventory_change();
CREATE TRIGGER test_trigger_delete BEFORE DELETE ON inventory FOR EACH ROW EXECUTE PROCEDURE record_inventory_change();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment