expects <function>sum</function> to behave that way. We can do this simply by

omitting the <literal>initcond</literal> phrase, so that the initial state

condition is null. Ordinarily this would mean that the <literal>sfunc</literal>

would need to check for a null state-condition input, but for

would need to check for a null state-condition input. But for

<function>sum</function> and some other simple aggregates like

<function>max</> and <function>min</>,

it is sufficient to insert the first nonnull input value into

It requires

two pieces of running state: the sum of the inputs and the count

of the number of inputs. The final result is obtained by dividing

these quantities. Average is typically implemented by usinga

two-elementarray as the state value. For example,

these quantities. Average is typically implemented by usingan

array as the state value. For example,

the built-in implementation of <function>avg(float8)</function>

looks like:

sfunc = float8_accum,

stype = float8[],

finalfunc = float8_avg,

initcond = '{0,0,0}'

initcond = '{0,0}'

);

</programlisting>

(<function>float8_accum</> requires a three-element array, not just

two elements, because it accumulates the sum of squares as well as

the sum and count of the inputs. This is so that it can be used for

some other aggregates besides <function>avg</>.)

</para>

<para>