Also no result with FROM __my_table LIMIT 1;
2013/2/19 Peter Kroon <plakroon@gmail.com>
> 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
>>>
>>
>>
>
