On PostgreSQL 9.1 i can execute this two queries with out any errors, with correct result:\[code\]SELECT xpath('/a', '<a s:dd="11"><c>test</c></a>')SELECT xpath('/a', '<a s:dd="11"><c>test</c></a>',ARRAY[ARRAY['s', 'http://example.com']])\[/code\]On PostgreSQL 9.2 same queries throws error:\[code\]ERROR: could not parse XML documentDETAIL: line 1: Namespace prefix s for dd on a is not defined\[/code\]Only this query works fine:\[code\]SELECT xpath('/a', '<a xmlns:s="ddd" s:dd="11"><c>test</c></a>')\[/code\]How can i parse XML file, whth out modifying XML code?Problems starts when i want to make xpath query for xml element, recived from previous query.For example xml document:\[code\] <some xmlns:my="somens"> <a> <b my
aram="11" /> </a> </some>\[/code\]And i want to do something like this:\[code\] elem = xpath('/a',doc); elem2= xpath('//b',elem[0]);\[/code\]And second row throws error, becouse of unknown prefix my. Any ideas?
aram="11" /> </a> </some>\[/code\]And i want to do something like this:\[code\] elem = xpath('/a',doc); elem2= xpath('//b',elem[0]);\[/code\]And second row throws error, becouse of unknown prefix my. Any ideas?