Re: Nested xmlagg doesn't give a result 9.2.3

Hi Michael,

This should have been the expected result on both machines:
-----------------------------------------------------------------------
<s_a><s_b i="1"><s_c i="1"/></s_b><s_b i="2"><s_c i="2"/></s_b></s_a>
(1 row)

I've just rebooted "PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled
by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit" and I'm getting the
expected result.

Thanks for helping.

Best,

Peter Kroon

2013/2/19 Michael Paquier <michael(dot)paquier(at)gmail(dot)com>

> Hi,
>
> With your query and such tables:
> create table __table (id int);
> insert into __table values (1),(2);
> create table __table_to_table (id int, table_id int);
> insert into __table_to_table values (1, 1),(2, 2);
>
> I am getting consistent results with 9.2.1 and 9.2.3 on my Linux box,
> hence:
> xmlelement
> -----------------------------------------------------------------------
> <s_a><s_b i="1"><s_c i="1"/></s_b><s_b i="2"><s_c i="2"/></s_b></s_a>
> (1 row)
>
> Could you be more explicit about the result you expect and the output
> differences you see between those versions?
> Regards,
> --
> Michael
>