Postgres Pro
Downloads
Home   >   mailing lists

Re: help for xml create in postgresql - Mailing list pgsql-general

From Craig Ringer
Subject Re: help for xml create in postgresql
Date
Msg-id 4E1CE032.1080803@postnewspapers.com.au
Whole thread Raw
In response to help for xml create in postgresql  (Jignesh Ramavat <ramavat.jignesh@gmail.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Fw: Re: [BUGS] BUG #6099: Does pgcluster support hibernate?
Next
From: Craig Ringer
Date:
Subject: Re: Alter Columns with Triggers