Re: [HACKERS] example for xmltable with XMLNAMESPACES

2017-04-13 Thread Alvaro Herrera
Arjen Nienhuis wrote: > It wasn't completely clear for me how to use namespaces in xmltable(). > Maybe add this to the documentation. It shows the default namespace > and quoting the namespace name. Thanks, pushed. -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Developm

[HACKERS] example for xmltable with XMLNAMESPACES

2017-03-27 Thread Arjen Nienhuis
It wasn't completely clear for me how to use namespaces in xmltable(). Maybe add this to the documentation. It shows the default namespace and quoting the namespace name. WITH xmldata(data) AS (VALUES (' http://example.com/myns"; xmlns:B="http://example.com/b";> '::xml) ) SELECT xmltable.*