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

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:

xpath differences between postgres 11.4 and 10.3

2019-07-05 Thread Felipe de Jesús Molina Bravo
Hi!! I have an strange behavior between 11.4 and 10.3 with xpath function: With pgsql 10.3 i have: select xpath('@idc', '' ) ; xpath {4776} (1 fila) and with pgsql 11.4: select xpath('@idc', ''::xml ) ; xpath --- {} (1 fila) Now, if change the expression wi