Re: Nested xmlagg doesn't give a result 9.2.3 - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: Nested xmlagg doesn't give a result 9.2.3
Date
Msg-id CAB7nPqREe7VVDq1Md6i2EBq954T4KR-49+6cegHrXKJDzOOJgQ@mail.gmail.com
Whole thread Raw
In response to Nested xmlagg doesn't give a result 9.2.3  (Peter Kroon <plakroon@gmail.com>)
Responses Re: Nested xmlagg doesn't give a result 9.2.3  (Peter Kroon <plakroon@gmail.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Peter Kroon
Date:
Subject: Nested xmlagg doesn't give a result 9.2.3
Next
From: Maciek Sakrejda
Date:
Subject: Re: BUG #7883: "PANIC: WAL contains references to invalid pages" on replica recovery