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.paquier@gmail.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
>