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
|