From c98e0a85c3a00702ca4276cdb41f2264aa18a95a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 19 Jan 2024 14:14:36 +0000 Subject: [PATCH] Add missing FROM clauses --- db/schemas/lib/triggers/create/biography.m4 | 2 ++ 1 file changed, 2 insertions(+) diff --git a/db/schemas/lib/triggers/create/biography.m4 b/db/schemas/lib/triggers/create/biography.m4 index 7585cb9..404ecf6 100644 --- a/db/schemas/lib/triggers/create/biography.m4 +++ b/db/schemas/lib/triggers/create/biography.m4 @@ -312,6 +312,7 @@ CREATE OR REPLACE FUNCTION biography_func () BEGIN SELECT comm_membs.startdate, comm_membs.commmid INTO startdate, commmid + FROM comm_membs WHERE comm_membs.animid = NEW.animid AND comm_membs.startdate < NEW.entrydate; IF FOUND THEN @@ -340,6 +341,7 @@ CREATE OR REPLACE FUNCTION biography_func () BEGIN SELECT comm_membs.enddate, comm_membs.commmid INTO enddate, commmid + FROM comm_membs WHERE comm_membs.animid = NEW.animid AND NEW.departdate < comm_membs.enddate; IF FOUND THEN -- 2.34.1