Postgres Pro
Downloads
Home   >   mailing lists

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

From Felipe de Jesús Molina Bravo
Subject Re: xpath differences between postgres 11.4 and 10.3
Date
Msg-id CALrs2KM7iqBSKKvYxN7g+BCy=a=pn6yMAKzA2dZ4z0YdRpBPMw@mail.gmail.com
Whole thread Raw
In response to xpath differences between postgres 11.4 and 10.3  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
ok David I get it! now i undestand the note!!

very grateful with your answer

See you!!



El sáb., 6 jul. 2019 a las 2:29, David G. Johnston (<david.g.johnston@gmail.com>) escribió:
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: "David G. Johnston"
Date:
Subject: xpath differences between postgres 11.4 and 10.3
Next
From: Peter Eisentraut
Date:
Subject: Re: pglogical extension. - 2 node master <-> master logicalreplication ?