Re: [GENERAL] XMLEXISTS on legacy XML with malformed xmlns

2016-02-12 17:53 GMT+01:00 Edson Richter : > > 2016-02-12 1:53 GMT+01:00 Edson Richter : > >> Hi! >> >> I've some (about 1M records) containing legacy XML I would like to parse >> and apply XMLEXISTS. >> >> This is the query: >> >> select * from xmllog >> where xpath_exists(('//MyDocument[@DocNum

Re: [GENERAL] XMLEXISTS on legacy XML with malformed xmlns

2016-02-12 1:53 GMT+01:00 Edson Richter >: Hi! I've some (about 1M records) containing legacy XML I would like to parse and apply XMLEXISTS. This is the query: select * from xmllog where xpath_exists(('//MyDocument[@DocNum = ''000

Re: [GENERAL] XMLEXISTS on legacy XML with malformed xmlns

2016-02-12 1:53 GMT+01:00 Edson Richter : > Hi! > > I've some (about 1M records) containing legacy XML I would like to parse > and apply XMLEXISTS. > > This is the query: > > select * from xmllog > where xpath_exists(('//MyDocument[@DocNum = ''000411828'']'::text), > xmlparse(document cdataout));