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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
