Thread: pgsql: Accept TEXT and CDATA nodes in XMLTABLE's column_expression.

Accept TEXT and CDATA nodes in XMLTABLE's column_expression.

Column expressions that match TEXT or CDATA nodes must return the
contents of the nodes themselves, not the content of non-existing
children (i.e. the empty string).

Author: Markus Winand
Reported-by: Markus Winand
Reviewed-by: Álvaro Herrera
Discussion: https://postgr.es/m/0684A598-002C-42A2-AE12-F024A324EAE4@winand.at

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b7f0be9a7e7ec1eb7b9780b169366495f24bf975

Modified Files
--------------
src/backend/utils/adt/xml.c         | 24 ++++++++++++++----------
src/test/regress/expected/xml.out   | 12 ++++++------
src/test/regress/expected/xml_2.out | 12 ++++++------
src/test/regress/sql/xml.sql        |  4 ++--
4 files changed, 28 insertions(+), 24 deletions(-)