From 8b602bdb104461b70582cd64ac1ca61fb4839cbb Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 13 Jun 2017 20:47:48 +0000 Subject: [PATCH] fix yet another error Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index be25558b21..9afb840004 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -222,7 +222,7 @@ BEGIN thes_code := '|'; ELSIF thes_code = 'z' THEN thes_code := COALESCE( oils_xpath_string('//*[@tag="040"]/*[@code="f"][1]', marcxml), '' ); - ELSE THEN + ELSE SELECT code INTO thes_code FROM authority.thesaurus WHERE short_code = thes_code; IF NOT FOUND THEN thes_code := '|'; -- default 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 cceecc1e26..cd4875a4ed 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql +++ b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.thesauri.sql @@ -449,7 +449,7 @@ BEGIN thes_code := '|'; ELSIF thes_code = 'z' THEN thes_code := COALESCE( oils_xpath_string('//*[@tag="040"]/*[@code="f"][1]', marcxml), 'z' ); - ELSE THEN + ELSE SELECT code INTO thes_code FROM authority.thesaurus WHERE short_code = thes_code; IF NOT FOUND THEN thes_code := '|'; -- default -- 2.11.0