Re: problem using a xpath function

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: erithema <fillodps2000(at)libero(dot)it>
Subject: Re: problem using a xpath function
Date: 2008-08-11 11:25:10
Message-ID: 200808111425.11735.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2008-08-11 11:26:00 Re: compiling Xpath functions in PostgreSQL 8.3.3
Previous Message Magnus Hagander 2008-08-11 09:10:12 Re: pg_restore fails on Windows