1 -- Evergreen DB patch 0727.function.xml_pretty_print.sql
3 -- A simple pretty printer for XML.
4 -- Particularly useful for debugging the biblio.record_entry.marc field.
8 -- check whether patch can be applied
9 SELECT evergreen.upgrade_deps_block_check('0727', :eg_version);
11 CREATE OR REPLACE FUNCTION evergreen.xml_pretty_print(input XML)
15 SELECT xslt_process($1::text,
16 $$<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
18 <xsl:output method="xml" omit-xml-declaration="yes" indent="yes"/>
19 <xsl:strip-space elements="*"/>
20 <xsl:template match="@*|node()">
22 <xsl:apply-templates select="@*|node()"/>
29 COMMENT ON FUNCTION evergreen.xml_pretty_print(input XML) IS
30 'Simple pretty printer for XML, as written by Andrew Dunstan at http://goo.gl/zBHIk';