From: | Nasruddin NA <nasruddin(dot)java(at)gmail(dot)com> |
---|---|
To: | pgsql-in-general(at)postgresql(dot)org |
Subject: | Using Xpath, Output value is not displaying in Single Line |
Date: | 2013-11-13 11:30:59 |
Message-ID: | CAMsH2L2SgFLgrGsJKb5MKi8XdrofUrVJOyfAe04tnkqbboTpjQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-in-general |
Hi All,
I am using following query for xpath,
SELECT ((xpath('//Grading_Manual',xmlgrading))[1]::text) As xpath from
km_course_mast WHERE ID=100006
*Output for this is in multiple lines after copying into editor*
"<Grading_Manual>
<PassorFail>PassFailM</PassorFail>
<Point>Pointtext</Point>
<Percentage>Percentagetext</Percentage>
<LetterBased>
<Sequence value="0">
<Letter>Lettertext</Letter>
<From>1</From>
<To>2</To>
</Sequence>
<Sequence value="1">
<Letter>Lettertext</Letter>
<From>3</From>
<To>4</To>
</Sequence>
<Sequence value="2">
<Letter>Lettertext</Letter>
<From>5</From>
<To>6</To>
</Sequence>
<Sequence value="3">
<Letter>Lettertext</Letter>
<From>7</From>
<To>8</To>
</Sequence>
<Sequence value="4">
<Letter>Lettertext</Letter>
<From>9</From>
<To>10</To>
</Sequence>
</LetterBased>
<Rubic>
<Upload>Uploadtext</Upload>
<url>urltext</url>
<Enter>Entertext</Enter>
</Rubic>
</Grading_Manual>"
I want output in single line like below
<Grading_Automated><PassOrFail>Pass</PassOrFail><ActivityScorebased><AutomatedSequence
Value="0"><Percentage>123</Percentage><Value>321</Value></AutomatedSequence><AutomatedSequence
Value="1"><Percentage>234</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
Value="2"><Percentage>431</Percentage><Value>2321</Value></AutomatedSequence><AutomatedSequence
Value="3"><Percentage>432</Percentage><Value>3231</Value></AutomatedSequence><AutomatedSequence
Value="4"><Percentage>333</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
Value="5"><Percentage>451</Percentage><Value>34321</Value></AutomatedSequence></ActivityScorebased></Grading_Automated>','<Grading_Automated><PassOrFail>Fail</PassOrFail><ActivityScorebased><AutomatedSequence
Value="0"><Percentage>123</Percentage><Value>321</Value></AutomatedSequence><AutomatedSequence
Value="1"><Percentage>234</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
Value="2"><Percentage>431</Percentage><Value>2321</Value></AutomatedSequence><AutomatedSequence
Value="3"><Percentage>432</Percentage><Value>3231</Value></AutomatedSequence><AutomatedSequence
Value="4"><Percentage>333</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
Value="5"><Percentage>451</Percentage><Value>34321</Value></AutomatedSequence></ActivityScorebased></Grading_Automated>
Please any one suggest me why it is in multiple line and how to convert to
single line in query level.
Thanks,
Nasruddin
From | Date | Subject | |
---|---|---|---|
Next Message | Radovan Jablonovsky | 2013-11-13 16:54:24 | Re: Using Xpath, Output value is not displaying in Single Line |
Previous Message | Hendré Louw | 2013-10-18 06:34:05 | Bash Scripting Best |