Using Xpath, Output value is not displaying in Single Line

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

Responses

Browse pgsql-in-general by date

  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