From 5235d4055eb4eabbbd12eeb5330990a5d99a4668 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 6 Feb 2014 09:54:16 -0500 Subject: [PATCH] unapi.mmr thinko repair Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/990.schema.unapi.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/990.schema.unapi.sql b/Open-ILS/src/sql/Pg/990.schema.unapi.sql index e51e0f8962..ea5594bb10 100644 --- a/Open-ILS/src/sql/Pg/990.schema.unapi.sql +++ b/Open-ILS/src/sql/Pg/990.schema.unapi.sql @@ -1424,7 +1424,7 @@ BEGIN parts := parts || xpath(sub_xpath, subrec.marc::XML)::TEXT[]; END LOOP; - SELECT ARRAY_TO_STRING( ARRAY_AGG( DISTINCT p ), '' )::XML INTO subxml FROM UNNEST(parts); + SELECT ARRAY_TO_STRING( ARRAY_AGG( DISTINCT p ), '' )::XML INTO subxml FROM UNNEST(parts) p; -- append data from the subordinate records to the -- main record document before applying the XSLT diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql b/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql index d456d8242a..ea1d6a300d 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql +++ b/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql @@ -344,7 +344,7 @@ BEGIN parts := parts || xpath(sub_xpath, subrec.marc::XML)::TEXT[]; END LOOP; - SELECT ARRAY_TO_STRING( ARRAY_AGG( DISTINCT p ), '' )::XML INTO subxml FROM UNNEST(parts); + SELECT ARRAY_TO_STRING( ARRAY_AGG( DISTINCT p ), '' )::XML INTO subxml FROM UNNEST(parts) p; -- append data from the subordinate records to the -- main record document before applying the XSLT -- 2.11.0