summaryrefslogtreecommitdiff
path: root/util/updates/update_2.22.sql
blob: 3268481e1853e9d79759435a476e9f07a81beacc (plain)
1
2
3
4
5
6
7
8
9
10
11


DROP TRIGGER vn_vnsearch_notify ON vn;

CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON vn FOR EACH ROW
  WHEN (OLD.c_search IS NOT NULL AND NEW.c_search IS NULL
     OR NEW.latest IS DISTINCT FROM OLD.latest
  ) EXECUTE PROCEDURE vn_vnsearch_notify();

\i util/sql/func.sql