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

From Peter Kroon
Subject Re: Nested xmlagg doesn't give a result 9.2.3
Date
Msg-id CAOh+DO=WVGM9MauUTjAU5finu7+5Yrmdt0YFEsLP=tdTcJRbVQ@mail.gmail.com
Whole thread Raw
In response to Re: Nested xmlagg doesn't give a result 9.2.3  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Nested xmlagg doesn't give a result 9.2.3
List pgsql-bugs
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
>

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: BUG #7890: wrong behaviour using pg_rotate_logfile() with parameter log_truncate_on_rotation = on
Next
From: Peter Kroon
Date:
Subject: Re: Nested xmlagg doesn't give a result 9.2.3