On 11/07/2011 3:44 PM, Jignesh Ramavat wrote:
*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>
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