From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-10-02 02:57:50 |
Message-ID: | 98DC2665-75D3-4B2F-BACA-7DEED9A0C118@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sep 1, 2010, at 11:52 AM, Pavel Stehule wrote:
>> regression=# create or replace function array_agg_transfn_strict(internal, anyelement) returns internal as 'array_agg_transfn' language internal immutable;
>> CREATE FUNCTION
>> regression=# create aggregate array_agg_strict(anyelement) (stype = internal,
>> sfunc = array_agg_transfn_strict, finalfunc = array_agg_finalfn);
>> CREATE AGGREGATE
>> regression=# create or replace function array_agg_transfn_strict(internal, anyelement) returns internal as 'array_agg_transfn' language internal strict immutable;
>> CREATE FUNCTION
>>
>
> nice dark trick :) - but it doesn't work
>
> ERROR: aggregate 16395 needs to have compatible input type and transition type
> postgres=#
I could use this trick now. Anyone got any bright ideas how to fix it?
Thanks,
David
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2010-10-02 11:36:50 | missing tags |
Previous Message | Josh Kupershmidt | 2010-10-02 00:36:36 | Re: I: About "Our CLUSTER implementation is pessimal" patch |