From ca0fc2d2eac1fcac16fa43c21ba71485309a162d Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 15:25:46 +0000 Subject: [PATCH] Execute REPRO_STATES.Date v.s. DepartDate check only when necessary --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index 5e54303..a280928 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -664,7 +664,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () END IF; END IF; - IF NEW.departdate <> OLD.departdate THEN + IF NEW.departdate < OLD.departdate THEN SELECT repro_states.reid, repro_states.date , repro_states.state, repro_states.source , repro_states.estrusday, repro_states.estrusdaycert -- 2.34.1