Re: problem using a xpath function - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: problem using a xpath function
Date
Msg-id 200808111425.11735.peter_e@gmx.net
Whole thread Raw
In response to problem using a xpath function  (erithema <fillodps2000@libero.it>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pg_restore fails on Windows
Next
From: Peter Eisentraut
Date:
Subject: Re: compiling Xpath functions in PostgreSQL 8.3.3