Re: xml output

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 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:

<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 in advance!

bye, flo