Add an XML pretty printer database function user/mrpeters-isl/pgsql_xml_pretty_print_signoff
authorDan Scott <dan@coffeecode.net>
Sat, 17 Mar 2012 01:49:45 +0000 (21:49 -0400)
committerMichael Peters <mrpeters@library.in.gov>
Thu, 19 Apr 2012 14:25:44 +0000 (10:25 -0400)
commitdad78d58397b51108ccc93e287a5b285252b5dcc
tree76de66f8f0cd3b96e4a571dcb6b941f5e15086f7
parent3ca291c2c43d3237c5b591fe302e62c22449e97c
Add an XML pretty printer database function

Andrew Dunstan was kind enough to share an XML pretty printer function
for PostgreSQL, and it sure is handy when you're debugging things like
in-database unapi and MARCXML.

Note that it expects honest-to-goodness XML data type input, so for
biblio.record_entry.marc columns you'll need to cast it from TEXT.

Signed-off-by: Dan Scott <dan@coffeecode.net>
Signed-off-by: Michael Peters <mrpeters@library.in.gov>
Open-ILS/src/sql/Pg/000.functions.general.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.xml_pretty_print.sql [new file with mode: 0644]