Re: [GENERAL] help for xml create in postgresql

2011-07-12 Thread Craig Ringer 

On 11/07/2011 3:44 PM, Jignesh Ramavat wrote:

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












Use xmlagg and a subquery.

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] help for xml create in postgresql

2011-07-12 Thread 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:





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











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