Postgres Pro
Downloads
Home   >   mailing lists

Thread: {xml}

{xml}

From
Ramesh T
Date:
Hello,
          when i ran following  query on postgres 9.3,
SELECT  xmlagg(xmlelement(name e,part_id||',')) from part; 

result
..................
{xml}

how to get part_id's..? please let me know ..
advance thanks,
R..

Re: {xml}

From
David G Johnston
Date:
Ramesh T wrote
> Hello,
>           when i ran following  query on postgres 9.3,
> SELECT  xmlagg(xmlelement(name e,part_id||',')) from part;
>
> result
> ..................
> {xml}
>
> how to get part_id's..? please let me know ..
> advance thanks,
> R..

Are you using psql?  What version of PostgreSQL?

I am guessing "{xml}" is the client's way of saying that what you have is
"XML".  Try casting the final result to "text" and see what you get.

Otherwise...

version
PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit

Since this:

WITH vals (ids) AS (
VALUES ('1'),('2')
)
SELECT xmlagg(xmlelement(name "tag", ids))::text FROM vals;

works probably need to provide a self-contained example for someone to look
at.





--
View this message in context: http://postgresql.1045698.n5.nabble.com/xml-tp5814076p5814126.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.