Re: xml output
От | Florian Henge |
---|---|
Тема | Re: xml output |
Дата | |
Msg-id | 1195095617.80687.1282726384901.JavaMail.fmail@mwmweb080 обсуждение исходный текст |
Ответ на | Re: xml output (Thom Brown <thom@linux.com>) |
Ответы |
Re: xml output
|
Список | pgsql-novice |
--------------------- Von: Thom Brown Gesendet: 23.08.2010 14:09:05 An: Florian Henge Betreff: Re: [NOVICE] xml output On 23 August 2010 12:33, Florian Henge <[florian.henge82@web.de]> wrote: hi there! i wanted to ask how to get an xml output from a table like this: joe ian carl ben what i have is the following: SELECT xmlelement(name words, xmlforest(nachname)) FROM person SELECT xmlelement(name words, xmlforest(nachname)) FROM person but that gives me this: joe ian carl ben thanks in advance! bye, flo You need to use xmlagg: SELECT xmlelement(name words, xmlagg( xmlforest(first_name) ) ) FROM person Regards -- Thom Brown Registered Linux user: #516935 _________________________________ Hi! Thanks, that worked perfectly for me, except for one problem. I have like 20 times the name "Joe" in my table, but want to get it only once in the xml output file. How can is do this? I tried SELECT DISTINCT but it didn't work. Thanks in advance! ___________________________________________________________ Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief! Jetzt De-Mail-Adresse reservieren: https://produkte.web.de/go/demail02
В списке pgsql-novice по дате отправления: