From 4b48ad4fb2edf897b87d04467f8eaaaba82a258f Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <peter_e@gmx.net>
Date: Fri, 19 Jan 2007 16:58:46 +0000
Subject: Add support for converting binary values (i.e. bytea) into xml
 values, with new GUC parameter "xmlbinary" that controls the output encoding,
 as per SQL/XML standard.

---
 src/test/regress/expected/xml.out   | 14 ++++++++++++++
 src/test/regress/expected/xml_1.out |  6 ++++++
 src/test/regress/sql/xml.sql        |  4 ++++
 3 files changed, 24 insertions(+)

(limited to 'src/test')

diff --git a/src/test/regress/expected/xml.out b/src/test/regress/expected/xml.out
index db03e43f2ab..cfac9105d96 100644
--- a/src/test/regress/expected/xml.out
+++ b/src/test/regress/expected/xml.out
@@ -121,6 +121,20 @@ SELECT xmlelement(name foo, array[1, 2, 3]);
  <foo><element>1</element><element>2</element><element>3</element></foo>
 (1 row)
 
+SET xmlbinary TO base64;
+SELECT xmlelement(name foo, bytea 'bar');
+   xmlelement    
+-----------------
+ <foo>YmFy</foo>
+(1 row)
+
+SET xmlbinary TO hex;
+SELECT xmlelement(name foo, bytea 'bar');
+    xmlelement     
+-------------------
+ <foo>626172</foo>
+(1 row)
+
 SELECT xmlparse(content 'abc');
  xmlparse 
 ----------
diff --git a/src/test/regress/expected/xml_1.out b/src/test/regress/expected/xml_1.out
index 4534ae98cc5..b25df3d24b9 100644
--- a/src/test/regress/expected/xml_1.out
+++ b/src/test/regress/expected/xml_1.out
@@ -58,6 +58,12 @@ SELECT xmlelement(name foo, xml 'b<a/>r');
 ERROR:  no XML support in this installation
 SELECT xmlelement(name foo, array[1, 2, 3]);
 ERROR:  no XML support in this installation
+SET xmlbinary TO base64;
+SELECT xmlelement(name foo, bytea 'bar');
+ERROR:  no XML support in this installation
+SET xmlbinary TO hex;
+SELECT xmlelement(name foo, bytea 'bar');
+ERROR:  no XML support in this installation
 SELECT xmlparse(content 'abc');
 ERROR:  no XML support in this installation
 SELECT xmlparse(content '<abc>x</abc>');
diff --git a/src/test/regress/sql/xml.sql b/src/test/regress/sql/xml.sql
index 4492a62cdb0..804cd2c2d67 100644
--- a/src/test/regress/sql/xml.sql
+++ b/src/test/regress/sql/xml.sql
@@ -45,6 +45,10 @@ SELECT xmlelement(name foo, xml 'bar');
 SELECT xmlelement(name foo, text 'b<a/>r');
 SELECT xmlelement(name foo, xml 'b<a/>r');
 SELECT xmlelement(name foo, array[1, 2, 3]);
+SET xmlbinary TO base64;
+SELECT xmlelement(name foo, bytea 'bar');
+SET xmlbinary TO hex;
+SELECT xmlelement(name foo, bytea 'bar');
 
 
 SELECT xmlparse(content 'abc');
-- 
cgit v1.2.3