Re: Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])
Дата
Msg-id 25794.1201640819@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])  (Caleb Welton <cwelton@greenplum.com>)
Список pgsql-hackers
Дерево обсуждения 
Caleb Welton <cwelton@greenplum.com> writes:
> Forgive me if I'm being dense, but could you explain why

> int4_sum(bigint,int) must not be strict, but
> int4_avg_accum(bytea, int) can be strict?

The former is used with a NULL initial value, the latter isn't.
Read the fine print in the CREATE AGGREGATE man page about behavior
with strict transition functions.
        regards, tom lane

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