From 9b418ab3553823c57709043d6518f6ab8296ce8b Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 12 Sep 2023 18:44:43 -0500 Subject: [PATCH] Better docs for macro --- db/schemas/sokwedb/triggers/create/biography.m4 | 3 +++ 1 file changed, 3 insertions(+) diff --git a/db/schemas/sokwedb/triggers/create/biography.m4 b/db/schemas/sokwedb/triggers/create/biography.m4 index 3234270..a665148 100644 --- a/db/schemas/sokwedb/triggers/create/biography.m4 +++ b/db/schemas/sokwedb/triggers/create/biography.m4 @@ -71,6 +71,8 @@ dnl Variables required: dnl new_or_old Either NEW or OLD, depending on the momid to be checked. dnl msg_prefix The beginning of the error message. dnl +dnl Every sibling is checked, even NEW and OLD. +dnl dnl Restrictions: Must be used in a FOR EACH ROW insert or update dnl trigger function. changequote({,}) @@ -236,6 +238,7 @@ CREATE OR REPLACE FUNCTION biography_func () || ' sdb_min_m_birth sdb_min_m_birth_units.'; END IF; END IF; + -- See if one of this individual's parents were born too soon. SELECT biography.animid, biography.animname, biography.bdmin , biography.sex -- 2.34.1