[GENERAL] help for xml create in postgresql

[Jignesh Ramavat]

i need to create xml by using xml function in postgresql.

i can create following xml by using this query
Query:
SELECT  XMLELEMENT(name chapter,
XMLATTRIBUTES(
'1' AS number,
CURRENT_DATE as current_date),
XMLELEMENT(name document, XMLATTRIBUTES((select typeaccountcode from
typeaccount limit 1) AS doc_name)));

Result:

<chapter number="1" current_date="2011-07-11">
    <document doc_name="Billing"/>
</chapter>

*BUT IF i want result in following format then?*

<chapter number="1" current_date="2011-07-11">
    <document doc_name="Billing"/>
    <document doc_name="EManager"/>
    <document doc_name="Immunization"/>
    <document doc_name="NueMD"/>
    <document doc_name="NueMDSched"/>
    <document doc_name="SuperAccount"/>
    <document doc_name="UnivScheduler"/>
</chapter>

-- 
Thanks & Regards,
Jignesh Ramavat
Software Engineer
Yosa Technology Solutions Pvt. Ltd
09924407751