Caleb Welton <cwelton(at)greenplum(dot)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
In response to
pgsql-hackers by date
|Next:||From: Cristian Gafton||Date: 2008-01-29 21:08:25|
|Subject: Re: Large pgstat.stat file causes I/O storm |
|Previous:||From: Tom Lane||Date: 2008-01-29 21:00:49|
|Subject: Re: [PATCHES] Proposed patch: synchronized_scanning GUCvariable |