Postgres Pro
Downloads
Home   >   mailing lists

How to change content of xml datatype - Mailing list pgsql-general

From gajendra s v
Subject How to change content of xml datatype
Date
Msg-id CAHjig8--8HpqeqPjm9bg0UAO24avOCProKDxB0L3Y7-dLd9bWw@mail.gmail.com
Whole thread Raw
Responses Re: How to change content of xml datatype
List pgsql-general
Tree view
Hi All,


I need to change content of xml ,Please any one suggest me how to do,the xml is below


<Grading_Automated><PassOrFail>Fail</PassOrFail><ActivityScorebased><AutomatedSequence Value="0"/><Percentage>25</Percentage><Value>34</Value><AutomatedSequence Value="1"/><Percentage>99</Percentage><Value>432</Value><AutomatedSequence Value="2"/><Percentage>43</Percentage><Value>232</Value><AutomatedSequence Value="3"/><Percentage>43</Percentage><Value>323</Value><AutomatedSequence Value="4"/><Percentage>33</Percentage><Value>432</Value><AutomatedSequence Value="5"/><Percentage>45</Percentage><Value>3432</Value></ActivityScorebased></Grading_Automated>

I want xml like below,is there any way

 '<Grading_Automated><PassOrFail>Pass</PassOrFail><ActivityScorebased><AutomatedSequence Value="0"/><Percentage>40</Percentage><Value>34</Value><AutomatedSequence Value="1"/><Percentage>99</Percentage><Value>432</Value><AutomatedSequence Value="2"/><Percentage>43</Percentage><Value>232</Value><AutomatedSequence Value="3"/><Percentage>43</Percentage><Value>323</Value><AutomatedSequence Value="4"/><Percentage>33</Percentage><Value>432</Value><AutomatedSequence Value="5"/><Percentage>45</Percentage><Value>3432</Value></ActivityScorebased></Grading_Automated> 

pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: Re: Postgres as In-Memory Database?
Next
From: Rob Sargent
Date:
Subject: Re: How to change content of xml datatype