select Xpath is returning values with {}

From: gajendra s v <svgajendra(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: select Xpath is returning values with {}
Date: 2013-11-12 15:16:16
Message-ID: CAHjig8_K=sQO-d7C=9qd_LQsOyMsX69NABDHNNP1kPAKYrC8kw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

How to remove {} from output

I am using below query

select (xpath('//Grading_Automated',(select xmlgrading from km_course_mast
where id='100000'))) from km_course_mast where id='100000'

The out is below

"{"<Grading_Automated>

</Grading_Automated>"}"

Thanks,
Gajendra

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Crowell 2013-11-12 15:27:14 Re: GSSAPI server side on Linux, SSPI client side on Windows
Previous Message Brian Crowell 2013-11-12 15:15:58 Re: GSSAPI server side on Linux, SSPI client side on Windows