Re: Possible bug with array_agg

Pavel Stehule wrote:
> Hello
>
> 2009/11/19 Scott Bailey <artacus@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 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