strip useless whitespace from XML output for transfer size reduction

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / 990.schema.unapi.sql

diff --git a/Open-ILS/src/sql/Pg/990.schema.unapi.sql b/Open-ILS/src/sql/Pg/990.schema.unapi.sql
index d0e11c2..4cfa20c 100644 (file)
--- a/Open-ILS/src/sql/Pg/990.schema.unapi.sql
+++ b/Open-ILS/src/sql/Pg/990.schema.unapi.sql
@@ -222,6 +222,7 @@ BEGIN
         output := tmp_xml;
     END IF;
 
+    output := REGEXP_REPLACE(output::TEXT,E'>\\s+<','><','gs')::XML;
     RETURN output;
 END;
 $F$ LANGUAGE PLPGSQL;