From b74d3e906922eb132bfd7c86a6a87a7e0297c313 Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Wed, 19 Aug 2026 09:01:18 -0700 Subject: [PATCH] Use valid parent-age bounds in BIOGRAPHY_DATA --- db/schemas/lib/triggers/create/biography_data.m4 | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index fbbd394..a8b0a1a 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -217,13 +217,13 @@ CREATE OR REPLACE FUNCTION biography_data_func () WHERE (NEW.sex = 'sdb_female' AND biography_data.momid = NEW.animid AND biography_data.bdmax - > NEW.bdmin - - 'sdb_min_f_birth sdb_min_f_birth_units'::interval) + < NEW.bdmin + + 'sdb_min_f_birth sdb_min_f_birth_units'::interval) OR (NEW.sex = 'sdb_male' AND biography_data.dadid = NEW.animid AND biography_data.bdmax - > NEW.bdbin - - 'sdb_min_m_birth sdb_min_m_birth_units' + < NEW.bdmin + + 'sdb_min_m_birth sdb_min_m_birth_units' ::interval) ORDER BY biography_data.birthdate DESC LIMIT 1; -- 2.34.1