[GENERAL] Alternate way of xpath - Mailing list pgsql-general

From dhaval jaiswal
Subject [GENERAL] Alternate way of xpath
Date
Msg-id PN1PR01MB004627C2D23C1C1226468A84DF5A0@PN1PR01MB0046.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: [GENERAL] Alternate way of xpath  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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

pgsql-general by date:

Previous
From: Christoph Moench-Tegeder
Date:
Subject: Re: [GENERAL] Query with type char
Next
From: JP Jacoupy
Date:
Subject: [GENERAL] Service configuration file and password security