From fdb36569b1e94f2252e4808b6cfc989c0748c235 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 19 Jan 2024 14:23:35 +0000 Subject: [PATCH] Testing for contiguous membership requires membership in one community --- db/schemas/lib/triggers/create/comm_membs.m4 | 1 + 1 file changed, 1 insertion(+) diff --git a/db/schemas/lib/triggers/create/comm_membs.m4 b/db/schemas/lib/triggers/create/comm_membs.m4 index 25f959f..4ed56b6 100644 --- a/db/schemas/lib/triggers/create/comm_membs.m4 +++ b/db/schemas/lib/triggers/create/comm_membs.m4 @@ -84,6 +84,7 @@ CREATE OR REPLACE FUNCTION comm_membs_func () FROM comm_membs WHERE comm_membs.commmid <> NEW.commmid AND comm_membs.animid = NEW.animid + AND comm_membs.commid = NEW.commid AND (comm_membs.enddate = NEW.startdate - 1 OR comm_membs.startdate = NEW.enddate + 1); IF FOUND THEN -- 2.34.1