Re: Aggregate from CASE WHEN...

Поиск
Список
Период
Сортировка
От Ioannis Anagnostopoulos
Тема Re: Aggregate from CASE WHEN...
Дата
Msg-id 4FFA1007.9090409@anatec.com
обсуждение исходный текст
Ответ на Re: Aggregate from CASE WHEN...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Aggregate from CASE WHEN...
Следующее
От: "Della-Croce, Gregory"
Дата:
Сообщение: A very simple question about rollback/commit