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.paqu...@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 >
