Postgres Pro
Downloads
Home   >   mailing lists

Re: how to create aggregate xml document in 8.3? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to create aggregate xml document in 8.3?
Date
Msg-id 9400.1197420880@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to create aggregate xml document in 8.3?  ("Matt Magoffin" <postgresql.org@msqr.us>)
Responses Re: how to create aggregate xml document in 8.3?
List pgsql-general
Tree view 
"Matt Magoffin" <postgresql.org@msqr.us> writes:
> Thanks very much, that helps. Now I'm wondering if it's also possible to
> then fill in another nested element level in the XML output, from the rows
> that are aggregated into the <range> count.

Something involving xmlagg in the sub-query, perhaps?  No time to
experiment with it now.

            regards, tom lane

pgsql-general by date:

Previous
From: Leigh Dyer
Date:
Subject: Multiple clusters on one box for PITR
Next
From: Ron St-Pierre
Date:
Subject: Re: top posting