XMLCONCAT

说明

该函数用于连接多个XMLType实例，并生成新的XMLType实例。（兼容Oracle、PostgreSQL）

语法

xmlconcat ::=

xmlconcat::=XMLCONCAT(xmltype_instance [,...n])

参数

xmltype_instance

用于指定XMLType实例

返回值

Xpath表达式指向节点的值

示例

示例1:

SQL=> SELECT xmlconcat('<abc/>', '<bar>foo</bar>');
    xmlconcat
-----------------------
<abc/><bar>foo</bar>
(1 row)

示例2:

CREATE TABLE PERSON
(
 name VARCHAR(128),
 age INT,
 email VARCHAR(128)
);

INSERT INTO PERSON VALUES
('John', 30, 'johnwatson@sh.com'),
('Sherlock',32,'sherlock@sh.com'),
('Mycroft', 41, 'mycroft@sh.com');

SQL=> SELECT xmlconcat(xmlelement("name",name),xmlelement("age",age)) xml FROM PERSON;
                XML
-------------------------------------
<name>John</name><age>30</age>
<name>Sherlock</name><age>32</age>
<name>Mycroft</name><age>41</age>
<name>John</name><age>30</age>
<name>Sherlock</name><age>32</age>
<name>Mycroft</name><age>41</age>
(6 rows)