| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Jignesh Ramavat <ramavat(dot)jignesh(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: help for xml create in postgresql |
| Date: | 2011-07-13 00:00:50 |
| Message-ID: | 4E1CE032.1080803@postnewspapers.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2011-07-13 00:09:38 | Re: Alter Columns with Triggers |
| Previous Message | Craig Ringer | 2011-07-12 23:58:30 | Re: Fw: Re: [BUGS] BUG #6099: Does pgcluster support hibernate? |