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

From Tom Lane
Subject Re: Aggregate from CASE WHEN...
Date
Msg-id 17734.1341788072@sss.pgh.pa.us
Whole thread Raw
In response to Re: Aggregate from CASE WHEN...  (Ioannis Anagnostopoulos <ioannis@anatec.com>)
Responses Re: Aggregate from CASE WHEN...  (Ioannis Anagnostopoulos <ioannis@anatec.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Ioannis Anagnostopoulos
Date:
Subject: Re: Aggregate from CASE WHEN...
Next
From: Ioannis Anagnostopoulos
Date:
Subject: Re: Aggregate from CASE WHEN...