xpath differences between postgres 11.4 and 10.3

2019-07-06 Thread David G. Johnston
On Friday, July 5, 2019, Felipe de Jesús Molina Bravo <
fjmolinabr...@gmail.com> wrote:

> '
>
> *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::attribute[id]

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

/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.


Re: xpath differences between postgres 11.4 and 10.3

2019-07-06 Thread Felipe de Jesús Molina Bravo
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.johns...@gmail.com>) escribió:

> On Friday, July 5, 2019, Felipe de Jesús Molina Bravo <
> fjmolinabr...@gmail.com> wrote:
>
>> '
>>
>> *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::attribute[id]
>
> In v11 relative pathing looks like (document root node):
>
> /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.
>
>