PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16046
PG Version12.0
OSWindows 7
Opened2019-10-09 09:22:05+00
Reported byMohammad Mostafa Kamal
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16046
Logged by:          Mohammad Mostafa Kamal
Email address:      (redacted)
PostgreSQL version: 12.0
Operating system:   Windows 7
Description:        

While using xpath to extract text from a CDATA section of xml, it returns
CDATA tag along with the value. 

Query: SELECT
unnest(xpath('//cname/aname/text()','<cname><aname><![CDATA[select
5]]></aname></cname>'::xml))

Output - pg11: select 5 

Output - pg12:  <![CDATA[select 5]]>

Messages

DateAuthorSubject
2019-10-09 09:22:05+00PG Bug reporting formBUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-10-24 21:38:11+00Tom LaneRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-10-24 23:14:48+00Chapman FlackRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-10-24 23:34:09+00Chapman FlackRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-10-25 01:45:44+00Chapman FlackRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-10-25 17:16:52+00Markus WinandRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-10-25 17:27:52+00Tom LaneRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-11-05 16:28:01+00Pavel StehuleRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
2019-11-14 03:00:22+00Mohammad Mostafa KamalRe: BUG #16046: xpath returns CDATA tag along with the value in postgres 12