From:
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"David E(dot) Wheeler" <david(at)kineticode(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:27:42
Message-ID:
AANLkTi=vAhu6Q+579pXWaXe-6qyXvTA0+F7t3UA447MU@mail.gmail.com (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
2010/9/1 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "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 ...
>
I am checking this now, and it is not possible - it needs a some
initial value and there isn't possible to set a "internal" value.
probably some C coding is necessary.
Regards
Pavel
> regards, tom lane
>
In response to
Responses
pgsql-hackers by date
Next :From: Jeff DavisDate: 2010-09-01 18:32:50Subject : compiling with RELCACHE_FORCE_RELEASE doesn't pass regressionPrevious :From : Tom LaneDate : 2010-09-01 18:25:51Subject : Re: array_agg() NULL Handling
