Skip site navigation (1) Skip section navigation (2)

Re: array_agg() NULL Handling

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Thom Brown <thom(at)linux(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: array_agg() NULL Handling
Date: 2010-09-01 07:03:41
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
On Aug 31, 2010, at 11:56 PM, Thom Brown wrote:

>>> The first form of aggregate expression invokes the aggregate across all input rows for which the given expression(s) yield non-null values. (Actually, it is up to the aggregate function whether to ignore null values or not — but all the standard ones do.)
>> --
>> That, however, is not true of array_agg():
>> try=# CREATE TABLE foo(id int);
>> try=# INSERT INTO foo values(1), (2), (NULL), (3);
>> INSERT 0 4
>> try=# select array_agg(id) from foo;
>>  array_agg
>> ──────────────
>>  {1,2,NULL,3}
>> (1 row)
>> So are the docs right, or is array_agg() right?
> I think it might be both.  array_agg doesn't return NULL, it returns
> an array which contains NULL.

No, string_agg() doesn't work this way, for example:

select string_agg(id::text, ',') from foo;
(1 row)

Note that it's not:

select string_agg(id::text, ',') from foo;
(1 row)



In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2010-09-01 07:11:39
Subject: Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)
Previous:From: Thom BrownDate: 2010-09-01 06:56:58
Subject: Re: array_agg() NULL Handling

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group