From 0b8001f8dee59938935d9d31df67bae56738f15f Mon Sep 17 00:00:00 2001 From: Steven Callender Date: Fri, 15 Jun 2012 14:35:46 -0400 Subject: [PATCH] Changed master schema as well. --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index 1b150252e3..6f2913a184 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -157,7 +157,7 @@ DECLARE heading_text TEXT; tmp_text TEXT; first_sf BOOL; - auth_id INT DEFAULT oils_xpath_string('//*[@tag="901"]/*[local-name()="subfield" and @code="c"]', marcxml)::INT; + auth_id INT DEFAULT COALESCE(NULLIF(oils_xpath_string('//*[@tag="901"]/*[local-name()="subfield" and @code="c"]', marcxml), ''), '0')::INT; BEGIN SELECT control_set INTO cset FROM authority.record_entry WHERE id = auth_id; -- 2.11.0