Skip to content

Tag: xpath

PostgreSQL11 xpath query not working properly

When I execute below query in Postgres 10.12, it works properly. Output: But When I execute same query in Postgres 11.7, it is not working. What is the solution to fix this issue? Answer This is caused by this change: Correctly handle relative path expressions in xmltable(), xpath(), and other XML-handling functions (Markus Winand) Per the SQL standard, relative paths

Fixing set-returning functions are not allowed in UPDATE

After upgrading to Postgres 12 statement throws error set-returning functions are not allowed in UPDATE How to fix this ? In Postgres 9.1 it worked. I read similar answers here but they recomment to totally overwrite statement. Maybe there is simply change which makes this statement work ? Result should by any value of xpath expression in case if xpath