"Paolo Saudin" <paolo@xxxxxxxxxxx> 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
