Re: Nested xmlagg doesn't give a result 9.2.3

Mm..
The problem only occurs on a specific table in my DB.

--__my_table has 512 rows

SELECT * FROM __my_table; --gives me result

SELECT
--xmlagg(
xmlelement(name el_name,
id
)
--)
FROM __my_table;--gives me result

When un-commenting the xmlagg I get no result. otherwise the output will
look like:
"<el_name>1</el_name>"
"<el_name>2</el_name>"
"<el_name>3</el_name>"
etc....


2013/2/19 Peter Kroon <plakroon@gmail.com>

> 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
>>
>
>