Re: I probably don't understand aggregates.

Markus Neumann wrote
> I'm new to postgres, sql and mailing lists, so I think I'm in the right 
> place here.
> 
> I have a pl/pgsql function, that calls a selfwritten aggregate function 
> (consisting of stepfunction and finalfunction) and afterwards processes 
> the results.
> 
> The Problem:
> 
> if I call
>    SELECT myAggrFunction(x) FROM table;
> I get the correct and expected output.
> 
> but when myAggrFunction gets called inside the "wrapper"-function, the 
> finalfunction gets executed before all rows are processed and hence I 
> get a "Division by zero" error.
> 
> E.g.
>    SELECT myWrapperFunction(x) FROM table;
>    ERROR: division by zero
> 
> 
> myWrapperFunction would look something like:
> 
>    BEGIN
>      M := myAggrFunction(x);
>      --do some more stuff
>      RETURN M;
>    END;
> 
> I hope the description is somehow understandable.
> 
> Any feedback will be highly appreciated.
> 
> Markus

Is there a reason you cannot provide a self-contained example?

David J.




--
View this message in context: http://postgresql.1045698.n5.nabble.com/I-probably-don-t-understand-aggregates-tp5806879p5806885.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.