From f34eb77e6bb4dc5694464edacece937570963511 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 18 Aug 2017 21:09:12 +0000 Subject: [PATCH] fix thes to control set mapping Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql index 53a91336e0..351044d525 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql +++ b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql @@ -460,7 +460,9 @@ $func$ LANGUAGE PLPGSQL STABLE STRICT; CREATE OR REPLACE FUNCTION authority.map_thesaurus_to_control_set () RETURNS TRIGGER AS $func$ BEGIN IF NEW.control_set IS NULL THEN - SELECT authority.extract_thesaurus(NEW.marc) INTO NEW.control_set; + SELECT control_set INTO NEW.control_set + FROM authority.thesaurus + WHERE code = authority.extract_thesaurus(NEW.marc); END IF; RETURN NEW; -- 2.11.0