Hello 2009/11/19 Scott Bailey <artacus@xxxxxxxxxxx>: > On 8.4.0 I found that array_agg does not return a value when fed more than > 12,000 values. (12,000 worked and 13,000 did not.) > can you send a query? postgres=# create table f(a int); CREATE TABLE postgres=# insert into f select * from generate_series(1,100000); INSERT 0 100000 postgres=# select count(*) from (select unnest(array_agg(a)) from f) s; count -------- 100000 (1 row) it's look well Regards Pavel Stehule > Probably not a big deal because its not something you would typically do. I > was testing something else and ran into it. But if there is a limit there, > we should probably document it. > > Scott Bailey > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
