Re: [GENERAL] problem using a xpath function

Am Wednesday, 6. August 2008 schrieb erithema:>
> SELECT id_autori , xpath ('/Authority/Nome', testo)
> FROM autori
> WHERE xpath_bool('/Authority[Nome="ABELARDO"]', testo) ;
>
> I get this error:
> ERROR : the function xpath_bool(unknown , xml) do not exsist at character
> 69 HINT: no function matches the given name and argument types. You might
> need to add explicit type casts

The xpath_bool function takes its XML data as type text. The new xpath()
function uses the XML type. Those are two different sets of functions.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general