I installed postgresql on my sytem,I need to parse an xml file.When I am working on xpath() it is showing an error that function is notfound and i tried almost all xml functions in postgresql but it is giving me the same result.why so ? should I have to install any xml library inorder to avoid this?Please tell me its very important for me.
these were the errors which i got SELECT xpath('/my:a/text()', '<my:a xmlns:my="http://example.com">test</my:a>', ARRAY[ARRAY['my', 'http://example.com']]); ERROR: function xpath("unknown", "unknown", text[]) does not exist at character 8 HINT: No function matches the given name and argument types. You may need to add explicit type casts. STATEMENT: SELECT xpath('/my:a/text()', '<my:a xmlns:my="http://example.com">test</my:a>', ARRAY[ARRAY['my', 'http://example.com']]); ERROR: function xpath("unknown", "unknown", text[]) does not exist LINE 1: SELECT xpath('/my:a/text()', '<my:a xmlns:my="http://example... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts.