xml output
От | Florian Henge |
---|---|
Тема | xml output |
Дата | |
Msg-id | 49520099.2598462.1282563223209.JavaMail.fmail@mwmweb078 обсуждение исходный текст |
Ответы |
Re: xml output
|
Список | pgsql-novice |
hi there!i wanted to ask how to get an xml output from a table like this:<words><first_name>joe</first_name><first_name>ian</first_name><first_name>carl</first_name><first_name>ben</first_name></words>what ihave is the following: SELECT xmlelement(name words, xmlforest(nachname)) FROM person SELECT xmlelement(name words,xmlforest(nachname))FROM personbut that gives me this:<words><first_name>joe</first_name></words><words><first_name>ian</first_name></words><words><first_name>carl</first_name></words><words><first_name>ben</first_name></words>thanks inadvance!bye, flo Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief! JetztDe-Mail-Adresse reservieren: https://produkte.web.de/go/demail02
В списке pgsql-novice по дате отправления: