Re: Nested xmlagg doesn't give a result 9.2.3

>Don't you have for example problems with the client application you use?

Yes, with 1 table only. I'm not getting any results.
When I'm on the sql machine via localhost or 192.168.1.100 I'm getting
results.

2013/2/19 Michael Paquier <michael(dot)paquier(at)gmail(dot)com>

>
>
> On Tue, Feb 19, 2013 at 5:50 PM, Peter Kroon <plakroon(at)gmail(dot)com> wrote:
>
>> Also no result with FROM __my_table LIMIT 1;
>>
> I'm having correct results with PG 9.2 by using either xmlagg or
> xmlelement.
> For example:
> postgres=# SELECT xmlelement(name el_name, id) FROM __table LIMIT 1;
> xmlelement
> ----------------------
> <el_name>1</el_name>
> Or:
> postgres=# SELECT xmlagg(xmlelement(name el_name, id)) FROM __table;
> xmlagg
> ------------------------------------------
>
> <el_name>1</el_name><el_name>2</el_name>
> (1 row)
>
> Btw, such simple tests would have failed on the buildfarm for regression
> xml.sql, so this looks to be an error in your environment.
> Don't you have for example problems with the client application you use?
> --
> Michael
>