Re: [GENERAL] Cumulative aggregate

2006-09-27 Thread Tom Lane
"Paolo Saudin" <[EMAIL PROTECTED]> 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 > = float

[GENERAL] Cumulative aggregate

2006-09-27 Thread Paolo Saudin
Hi all, I want to write an aggregate to sum the values for rain precipitations. I found a working example with integer values, but I cannot find a way to to the same with float ones. Here is what I did :   -- table testcreate table mytest (fld1 int4, fld2 float4);insert into mytest values (1