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

From Peter Kroon
Subject Nested xmlagg doesn't give a result 9.2.3
Date
Msg-id CAOh+DO=TtnzF_MPPtnDn0WXNtjJpVpoPKwxm8RaB8yatr77vrQ@mail.gmail.com
Whole thread Raw
Responses Re: Nested xmlagg doesn't give a result 9.2.3
List pgsql-bugs
Query:

SELECT
xmlelement(name s_a,
xmlagg(
xmlelement(name s_b,
xmlattributes(
sq.id AS i
),
(SELECT
xmlagg(
xmlelement(name s_c,
xmlattributes(
su.id AS i
)
)
ORDER BY table_id,id
)
FROM __table_to_table AS su WHERE su.table_id=sq.id
)
)
)
)
FROM __table AS sq

No result given in: "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"
A result is given in: "PostgreSQL 9.2.1, compiled by Visual C++ build 1600,
32-bit"

Both installations tested with same DB.

pgsql-bugs by date:

Previous
From: Rafael Martinez
Date:
Subject: Re: BUG #7890: wrong behaviour using pg_rotate_logfile() with parameter log_truncate_on_rotation = on
Next
From: Michael Paquier
Date:
Subject: Re: Nested xmlagg doesn't give a result 9.2.3