xpath differences between postgres 11.4 and 10.3 - Mailing list pgsql-general

From David G. Johnston
Subject xpath differences between postgres 11.4 and 10.3
Date
Msg-id CAKFQuwZLVT0Y5X=4Z0BcqyNXpELaSGRK7JDoy8XHrSeK_=dt6g@mail.gmail.com
Whole thread Raw
In response to xpath differences between postgres 11.4 and 10.3  (Felipe de Jesús Molina Bravo <fjmolinabravo@gmail.com>)
Responses Re: xpath differences between postgres 11.4 and 10.3  (Felipe de Jesús Molina Bravo <fjmolinabravo@gmail.com>)
List pgsql-general
On Friday, July 5, 2019, Felipe de Jesús Molina Bravo <fjmolinabravo@gmail.com> wrote:
<p idc="4776" rc="Cuadro" idrg="5"/>'
  
Per the SQL standard, relative paths start from the document node of the XML input document, not the root node as these functions previously did.

The absolute path to the 4776 in the document is:

/p::attribute[id]

In v10 relative pathing looks like (root element node):

/p<you-are-here>::attribute[id]

In v11 relative pathing looks like (document root node):

/<you-are-here>p::attribute[id]

You either need to specify your root element name in your xpath expression or, less precisely, use // to look for the attribute anywhere

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Converting to identity columns with domains on PK columns
Next
From: Felipe de Jesús Molina Bravo
Date:
Subject: Re: xpath differences between postgres 11.4 and 10.3