From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
"David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc:
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>,
David Fetter <david(at)fetter(dot)org>,
PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: array_agg() NULL Handling
Date:
2010-09-01 18:25:51
Message-ID:
28391.1283365551@sss.pgh.pa.us (view raw or flat )
Thread:
2010-09-01 05:45:05 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 06:56:58 from Thom Brown <thom(at)linux(dot)com>
2010-09-01 07:03:41 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 08:06:48 from Thom Brown <thom(at)linux(dot)com>
2010-09-01 16:02:12 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 07:30:08 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-01 15:16:41 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 17:47:21 from David Fetter <david(at)fetter(dot)org>
2010-09-01 17:52:35 from Thom Brown <thom(at)linux(dot)com>
2010-09-01 17:59:42 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-02 09:47:14 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-09-01 18:09:48 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-01 18:12:37 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 18:25:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-01 18:27:42 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-01 18:46:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-01 18:52:40 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-10-02 02:57:50 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 16:08:04 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 17:12:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-01 17:16:05 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 17:30:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-01 18:06:51 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-01 18:23:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
"David E. Wheeler" <david(at)kineticode(dot)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
In response to
Responses
pgsql-hackers by date
Next :From: Pavel StehuleDate: 2010-09-01 18:27:42Subject : Re: array_agg() NULL HandlingPrevious :From : Tom LaneDate : 2010-09-01 18:23:32Subject : Re: array_agg() NULL Handling
