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
