From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | dhaval jaiswal <dhavallj(at)hotmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Alternate way of xpath |
Date: | 2017-02-16 14:25:50 |
Message-ID: | 2b133a69-fc0b-6a58-7867-558dc10b47a5@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-02-16 14:30:44 | Re: Using ctid in delete statement |
Previous Message | Merlin Moncure | 2017-02-16 14:25:05 | Re: PostgreSQL corruption |