Skip site navigation (1) Skip section navigation (2)

errors while working on xml functions in postgresql

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 (view raw or flat)
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.




      


      

In response to

Responses

pgsql-general by date

Next:From: Francisco ReyesDate: 2008-07-28 17:11:38
Subject: Re: Clone a database to other machine
Previous:From: ChristopheDate: 2008-07-28 16:46:43
Subject: Re: Fetch for Update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group