"Paolo Saudin" <paolo@ecometer.it> writes:
> -- function for float (NOT WORKING)
> create function myfloat4_sum(float4,float4) returns float4
> as 'select float4pl($1,$2)::float4;'
> language SQL;
> -- aggregate
> create aggregate myagg2_sum (basetype = float4, sfunc = myfloat4_sum, stype
> = float4);
> -- result
> select myagg2_sum(fld2) from mytest; --> NOTHING ??? INSTEAD OF 6.73
> What am I doing wrong ??
(1) not marking the transition function as strict --- this affects the
behavior of the aggregate;
(2) not providing an initial condition.
regards, tom lane