From 73936f212293d36c49fb68bc2962b666d28fdd58 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sun, 12 Oct 2025 17:49:50 +0000 Subject: [PATCH] Fix test for minimum adolescent U swelling code --- 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 668d1b5..9fe5dc9 100644 --- a/db/schemas/lib/triggers/create/arrivals.m4 +++ b/db/schemas/lib/triggers/create/arrivals.m4 @@ -196,7 +196,7 @@ CREATE OR REPLACE FUNCTION arrivals_func () -- Can't be too young. IF a_birthdate - < (a_date + > (a_date - 'sdb_min_adolescent_age sdb_min_adolescent_age_units'::INTERVAL ) THEN RAISE EXCEPTION integrity_constraint_violation USING diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index 43bd22a..04c039d 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -661,7 +661,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 - 'sdb_min_adolescent_age sdb_min_adolescent_age_units'::INTERVAL ) -- Produce a consistent error message diff --git a/db/schemas/lib/triggers/create/follows.m4 b/db/schemas/lib/triggers/create/follows.m4 index 8ec0c5e..2b93d52 100644 --- a/db/schemas/lib/triggers/create/follows.m4 +++ b/db/schemas/lib/triggers/create/follows.m4 @@ -248,7 +248,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 - 'sdb_min_adolescent_age sdb_min_adolescent_age_units'::INTERVAL ) -- Produce a consistent error message -- 2.34.1