From 7191dd42e038c593643b55a6c262c8f974cb7fc8 Mon Sep 17 00:00:00 2001
From: Stevan Earl <stevan.earl@asu.edu>
Date: Thu, 13 Aug 2026 10:32:13 -0700
Subject: [PATCH] Add missing REPRO_STATES 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 d5879b4..c236632 100644
--- a/db/schemas/lib/triggers/create/biography_data.m4
+++ b/db/schemas/lib/triggers/create/biography_data.m4
@@ -709,6 +709,7 @@ CREATE OR REPLACE FUNCTION biography_data_func ()
              , a_state           , a_source
              , a_estrusday           , a_estrusdaycert
              , a_lactendcert            , a_parity
+          FROM repro_states
           WHERE repro_states.animid = NEW.animid
                 AND NEW.departdate < repro_states.date
           ORDER BY repro_states.date;  -- consistency
-- 
2.34.1