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