Re: Aggregate from CASE WHEN... - Mailing list pgsql-novice

On 08/07/2012 23:54, Tom Lane wrote:
> Ioannis Anagnostopoulos <ioannis@anatec.com> writes:
>> Now, for the final step of it. You said that SFUNC =
>> array_append form the example array_accum must be delclared "strict".
>> May I ask how as I am lost?
> You would need to create a new SQL function declaration, referencing the
> same underlying C code but marked strict.  Then make a new aggregate
> referencing that as the sfunc instead of the original.
>
>             regards, tom lane
Thank you, I was actually on my way to do exactly this...

Regards
Yiannis