Re: [GENERAL] Alternate way of xpath

On 02/16/2017 04:33 AM, dhaval jaiswal wrote:
> I have the following situation.
>
> PostgreSQL is  not configured with the option   --with-libxml
>
> Having one text column where i am trying to run the following command
> which is failing as expected its not configure with libxml. However, is
> there any alternate way through which i can achieve this.
>
> select xpath('///Name/text()', column1_xml::xml) from test;

Pull the text out and use another language to process:

https://en.wikipedia.org/wiki/XPath#Implementations

either externally or in a Postgres pl* function.

>
> ERROR:  unsupported XML feature
> DETAIL:  This functionality requires the server to be built with libxml
> support.
> HINT:  You need to rebuild PostgreSQL using --with-libxml.
>
>
>
> Sent from Outlook <http://aka.ms/weboutlook>
>


--
Adrian Klaver
adrian.klaver@aklaver.com