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