| From: | gajendra s v <svgajendra(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to change content of xml datatype |
| Date: | 2013-11-20 17:21:42 |
| Message-ID: | CAHjig8--8HpqeqPjm9bg0UAO24avOCProKDxB0L3Y7-dLd9bWw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2013-11-20 17:31:44 | Re: How to change content of xml datatype |
| Previous Message | Stefan Keller | 2013-11-20 17:02:50 | Re: Postgres as In-Memory Database? |