Re: Nested xmlagg doesn't give a result 9.2.3

> When I'm on the sql machine via localhost or 192.168.1.100 I'm getting
results.

I mean when I'm physically behind the machine and login via pgadmin
using localhost
or 192.168.1.100 then I get results.
When I'm on another machine and login via pgadmin(192.168.1.100) then I get
no results.
Not sure what to think of this...

2013/2/19 Peter Kroon <plakroon(at)gmail(dot)com>

> >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
>>
>
>