From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Scott Bailey <artacus(at)comcast(dot)net>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Subject: | Re: Possible bug with array_agg |
Date: | 2009-11-19 20:30:25 |
Message-ID: | 200911192130.25285.guillaume@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Le jeudi 19 novembre 2009 à 20:45:36, Scott Bailey a écrit :
> 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
>
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 100000 integers), but the query returns something that
pgAdmin tries to display. The others work too but the display is much better.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2009-11-19 20:34:20 | Re: Books |
Previous Message | Kovalevski Andrei | 2009-11-19 20:21:40 | Re: Encoding using the Frontend/Backend Protocol TCP/IP |