From 669017f79ff105f9dcec38bb4825a19139426fe4 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 30 Jun 2026 23:49:16 +0000 Subject: [PATCH] Fix inequality tests for being under study --- db/schemas/lib/triggers/create/watches.m4 | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/db/schemas/lib/triggers/create/watches.m4 b/db/schemas/lib/triggers/create/watches.m4 index db6c5c0..9cc7566 100644 --- a/db/schemas/lib/triggers/create/watches.m4 +++ b/db/schemas/lib/triggers/create/watches.m4 @@ -138,7 +138,7 @@ CREATE OR REPLACE FUNCTION watches_func () JOIN biography_data ON (biography_data.animid = roles.participant) WHERE events.wid = NEW.wid - AND biography_data.entrydate < NEW.date + AND NEW.date < biography_data.entrydate -- A consistent error message ORDER BY events.start, events.stop, events.eid , roles.participant, roles.role; @@ -190,7 +190,7 @@ CREATE OR REPLACE FUNCTION watches_func () JOIN biography_data ON (biography_data.animid = roles.participant) WHERE events.wid = NEW.wid - AND biography_data.departdate > NEW.date + AND biography_data.departdate < NEW.date -- A consistent error message ORDER BY events.start, events.stop, events.eid , roles.participant, roles.role; -- 2.34.1