Following the steps described in http://www.throwingbeans.org/postgresql_and_xml.html I was able to store an xml-document as a text and successfully run xpath-queries to retrieve data. However, as soon as I add namespaces and references to these in my document I run into problems. The thing is that my xpath-query returns all rows in the table without any content, as opposed to a "simple" xml-document without namespaces which would return the rows which matches my query.
Has anyone had any experience in this area and could nudge me in the right direction ?
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert