Postgres Pro
Downloads
Home   >   mailing lists

Re: array_agg() NULL Handling - Mailing list pgsql-hackers

From Tom Lane
Subject Re: array_agg() NULL Handling
Date
Msg-id 28391.1283365551@sss.pgh.pa.us
Whole thread Raw
In response to Re: array_agg() NULL Handling  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: array_agg() NULL Handling
List pgsql-hackers
Tree view 
"David E. Wheeler" <david@kineticode.com> writes:
> On Sep 1, 2010, at 11:09 AM, Pavel Stehule wrote:
>> Then you can eliminate NULLs with simple function

> Kind of defeats the purpose of the efficiency of the aggregate.

Well, you can build your own version of array_agg with the same
implementation, except you mark the transition function as strict ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: array_agg() NULL Handling
Next
From: Pavel Stehule
Date:
Subject: Re: array_agg() NULL Handling