Postgres Pro
Downloads
Home   >   mailing lists

BUG #16046: xpath returns CDATA tag along with the value in postgres 12 - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16046: xpath returns CDATA tag along with the value in postgres 12
Date
Msg-id 16046-a04d0611e7a0c03a@postgresql.org
Whole thread Raw
Responses Re: BUG #16046: xpath returns CDATA tag along with the value in postgres 12
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      16046
Logged by:          Mohammad Mostafa Kamal
Email address:      mostafa_bit0108@hotmail.com
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]]>

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #16045: vacuum_db crash and illegal memory alloc afterpg_upgrade from PG11 to PG12