From 0c69323bd92b572c668574cf5a490b2c6859d544 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sun, 12 Oct 2025 19:47:24 +0000 Subject: [PATCH] Fix maximum female adolescent swelling (sdb_adolsecent_swelling) test --- db/schemas/lib/triggers/create/arrivals.m4 | 2 +- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- db/schemas/lib/triggers/create/follows.m4 | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/db/schemas/lib/triggers/create/arrivals.m4 b/db/schemas/lib/triggers/create/arrivals.m4 index 9fe5dc9..b3b3ba0 100644 --- a/db/schemas/lib/triggers/create/arrivals.m4 +++ b/db/schemas/lib/triggers/create/arrivals.m4 @@ -243,7 +243,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () -- adolescent females. -- Can't be too old. IF a_birthdate - >= (a_date + <= (a_date - '1 year'::INTERVAL - 'sdb_max_adolescent_age sdb_max_adolescent_age_units'::INTERVAL ) THEN diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index 04c039d..50b41db 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -726,7 +726,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () WHERE roles.participant = NEW.animid AND arrivals.cycle = 'sdb_adolescent_swelling' AND NEW.birthdate - >= (follows.date + <= (follows.date - '1 sdb_max_adolescent_age_units'::INTERVAL - 'sdb_max_adolescent_age sdb_max_adolescent_age_units'::INTERVAL ) diff --git a/db/schemas/lib/triggers/create/follows.m4 b/db/schemas/lib/triggers/create/follows.m4 index 2b93d52..6c52650 100644 --- a/db/schemas/lib/triggers/create/follows.m4 +++ b/db/schemas/lib/triggers/create/follows.m4 @@ -316,7 +316,7 @@ CREATE OR REPLACE FUNCTION follows_func () AND arrivals.cycle = 'sdb_adolescent_swelling' AND biography_data.birthdate AND biology_data.birthdate - >= (NEW.date + <= (NEW.date - '1 sdb_max_adolescent_age_units'::INTERVAL - 'sdb_max_adolescent_age sdb_max_adolescent_age_units'::INTERVAL ) -- 2.34.1