From: | aravind chandu <avin_friends(at)yahoo(dot)com> |
---|---|
To: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
Subject: | errors while working on xml functions in postgresql |
Date: | 2008-07-28 17:01:01 |
Message-ID: | 443475.61103.qm@web31408.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
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.
Thanks,
Avin.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2008-07-28 17:11:38 | Re: Clone a database to other machine |
Previous Message | Christophe | 2008-07-28 16:46:43 | Re: Fetch for Update |