Request to mark postgresql group email while replying so it will help much if other's have better idea as well if any correction in my test case.
Whatever you have sent its very useful for me.I need to add one more node between the values,like
<values>Infosys<place>Bangalore</place></values>
How to add?
postgres=# update xdata set xmlcode='<values>Infosys<place>Bangalore</place></values>' where cast(xpath('//values/text()',xmlcode) as text[]) = '{Infosys}';
UPDATE 1
postgres=# select xmlparse(content xmlcode) from xdata ;