I probably don't understand aggregates.
От | Markus Neumann |
---|---|
Тема | I probably don't understand aggregates. |
Дата | |
Msg-id | 5398B415.70304@math.uzh.ch обсуждение исходный текст |
Ответы |
Re: I probably don't understand aggregates.
Re: I probably don't understand aggregates. |
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: