help for xml create in postgresql

Поиск
Список
Период
Сортировка
От Jignesh Ramavat
Тема help for xml create in postgresql
Дата
Msg-id CAG6nKmK7cmkQ1w9qS66sV5HPf67ewbUP=p8QzimNqkkHbVnF0w@mail.gmail.com
обсуждение исходный текст
Ответы Re: help for xml create in postgresql  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Re: Unexpected results with joins on dates
Следующее
От: Jonathan Barber
Дата:
Сообщение: Re: Slow queries (high duration) and their log entries appearing out-of-order