数据仓库服务 GAUSSDB(DWS)-产生XML内容:XMLSERIALIZE ( { DOCUMENT | CONTENT } value AS type

时间:2024-10-16 16:27:30

XMLSERIALIZE ( { DOCUMENT | CONTENT } value AS type

描述:从XML类型的值生成一个字符串。

返回值类型:type,可以是character,character varying或text(或其别名)

示例:

1
2
3
4
5
SELECT xmlserialize(content 'good' AS CHAR(10));
 xmlserialize
--------------
 good
(1 row)
support.huaweicloud.com/sqlreference-dws/dws_06_0351.html