From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: I probably don't understand aggregates. |
Date: | 2014-06-11 20:41:48 |
Message-ID: | 1402519308856-5806885.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2014-06-11 20:48:53 | Re: Need help with this Function. I'm getting an error |
Previous Message | Shubhra Sharma | 2014-06-11 20:40:07 | Need help with this Function. I'm getting an error |