Pavel Stehule wrote:
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
As you were. Above worked for me as well. It appears to be a problem
with pgAdmin.
-- Returns nothing
SELECT a
FROM (
select array_agg(a) a from f
) s
-- Works
SELECT a
FROM (
select array_agg(a) a from f
WHERE a < 12000
) s
-- Returns nothing
SELECT a
FROM (
select array_agg(a) a from f
WHERE a < 13000
) s
When I ran in different client all queries returned results.
Scott
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
