Alternate way of xpath

From: dhaval jaiswal <dhavallj(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Alternate way of xpath
Date: 2017-02-16 12:33:18
Message-ID: PN1PR01MB004627C2D23C1C1226468A84DF5A0@PN1PR01MB0046.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Sent from Outlook<http://aka.ms/weboutlook>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message JP Jacoupy 2017-02-16 13:57:52 Service configuration file and password security
Previous Message Christoph Moench-Tegeder 2017-02-16 10:30:11 Re: Query with type char