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 по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Need help. Getting an error in my function when I do a select * from foo_bar()
Следующее
От: Shubhra Sharma
Дата:
Сообщение: Need help with this Function. I'm getting an error