>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.paqu...@gmail.com> > > > On Tue, Feb 19, 2013 at 5:50 PM, Peter Kroon <plakr...@gmail.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 >
