[GENERAL] Delete xml node from xml-document

[Oleg Malyovaniy]

Hello!

 

I try to delete some node from xml using plpgsql language

How can I do it?

 

To sample

SELECT INTO xlst_templ '//myNode';

SELECT INTO v_xml XMLPARSE(DOCUMENT value) from myTable WHERE id=ids;

RAISE NOTICE '%', v_xml; -- variable v_xml contain my xml document.

SELECT INTO v_nodes xpath(xlst_templ, v_xml); -- variable v_nodes contain
array of xml elements "myNode"

 

what next?

How delete all nodes "myNode'" from document v_xml?

 

Thanks for your help.

 

Oleg A Malyovany