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.