From 896a13ab2b43e82e17e0d581dec8fa36e8c6c77e Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Thu, 13 Aug 2026 10:31:10 -0700 Subject: [PATCH] Add missing SWELLING_SOURCES FROM clause --- db/schemas/lib/triggers/create/biography_data.m4 | 1 + 1 file changed, 1 insertion(+) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index 06f71f7..d5879b4 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -618,6 +618,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () , swelling_sources.swellingmin, swelling_sources.swellingmax INTO a_id , a_date , a_swellingmin , a_swellingmax + FROM swelling_sources WHERE swelling_sources.animid = NEW.animid AND NEW.departdate < swelling_sources.date ORDER BY swelling_sources.date; -- consistency -- 2.34.1