I'm not sure which release you use, but it works for me (1.10 and 1.11). The result of the first query is badly displayed (remember that it tries to display an array of 100000 integers), but the query returns something that pgAdmin tries to display. The others work too but the display is much better.
Using 1.10. It displays nothing on Windows version. Displays a bunch of overlapping text on Linux. Oh well, that doesn't matter, as long as array_agg is doing what it should.
Scott -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general