Re: Possible bug with array_agg

Pavel Stehule wrote:
> Hello
>
> 2009/11/19 Scott Bailey <artacus(at)comcast(dot)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 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