From fc598078a3dbfd981cd4fee293109408ce5b0653 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 28 Aug 2018 14:14:52 -0400 Subject: [PATCH] remove nonbreaking spaces and trim spaces from org unit name --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index bc72c89601..b6f6fc272d 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -1470,7 +1470,7 @@ BEGIN FOR j IN 1 .. ARRAY_UPPER(uri_owner_list, 1) LOOP uri_owner := uri_owner_list[j]; - SELECT id INTO uri_owner_id FROM actor.org_unit WHERE shortname = uri_owner; + SELECT id INTO uri_owner_id FROM actor.org_unit WHERE shortname = BTRIM(REPLACE(uri_owner,chr(160),'')); CONTINUE WHEN NOT FOUND; -- we need a call number to link through -- 2.11.0