Hi,
I would like to have an opportunity to see that content of query result cell is too long to display.
F.e. situation:
I have query with array_agg function in one column. Most of rows bring up to 20 values, some ~100, only one row brings ~700 integer values, but in pgAdmin result grid this cell is empty and looks exactly like null value.
It took some time to figure out what is going on. Thread
http://archives.postgresql.org/pgsql-general/2009-11/msg00812.php helped.
It seems to me, that
principle of least
surprise is not applied there.
Thanks,
Grazvydas