Thread: [GENERAL] Alternate way of xpath
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;
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.
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;
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
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