[GENERAL] xml2 vs XMLFunctions

Hi, I am currently using xml2 functionality in PostgreSQL 8.3.x and want to substitute it by the newer API as mentioned here: >From PostgreSQL 8.3 on, there is XML-related functionality based on the SQL/XML standard in the core server. That functionality covers XML syntax checking and XPath

[GENERAL] xpath_bool_ns() and xml2

Hi, does anybody know how to use the xml2 function xpath_bool with namespaces. I have used this function successfully as long as my xml documents haven't contained namespaces. I searched with google and found some readme file where the function xpath_bool_ns was available that would probably

[GENERAL] How to check if an array is empty

Hi, in my special case I'd like to check if a XML[] is empty, because postgres doesn't implement any equality operators, this is not a 'simple' task. My current solution is: SELECT * FROM sometable WHERE XMLSERIALIZE(CONTENT ((XPATH('/a:bar, somexmlcolumn, ARRAY[ARRAY['a', 'http://foo]]