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.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
