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.)
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
Hello
2009/11/19 Scott Bailey arta...@comcast.net:
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
Scott Bailey arta...@comcast.net writes:
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.)
What do you mean by does not return a value?
In general, giving a specific test case is a lot more helpful than
this sort of
Pavel Stehule wrote:
Hello
2009/11/19 Scott Bailey arta...@comcast.net:
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
Le jeudi 19 novembre 2009 à 20:45:36, Scott Bailey a écrit :
Pavel Stehule wrote:
Hello
2009/11/19 Scott Bailey arta...@comcast.net:
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?
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 10 integers), but the query returns something that
pgAdmin tries to display. The others work too but the display is
2009/11/19 Scott Bailey arta...@comcast.net:
Pavel Stehule wrote:
Hello
2009/11/19 Scott Bailey arta...@comcast.net:
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