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 <plakr...@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.paqu...@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 >> > >
