From 503d496b232774e8db0aca723adea7819d97572b Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 5 Jun 2026 17:11:12 +0000 Subject: [PATCH] Fix inequality that broke ATTENDANCE under-study check --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index d674c8f..c1fa983 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -539,7 +539,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () INTO a_atid , a_date , a_commid FROM attendance WHERE attendance.animid = NEW.animid - AND attendance.date < NEW.departdate + AND NEW.departdate < attendance.date ORDER BY attendance.date; -- consistency IF FOUND THEN RAISE EXCEPTION integrity_constraint_violation USING -- 2.34.1