| From: | Michael Giannakopoulos <miccagiann(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | About aggregates... |
| Date: | 2012-11-29 21:06:43 |
| Message-ID: | CAAADf7LtTqvAwZLdp49o5A_e3nTWDmFuEJ8r0FfgVdeWebFQKQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello guys,
I would like to ask if there is any way to make an aggregate function to
take a set of tuples as an input variable. I know that an actual aggregate
function receives each tuple one at a time and process it on the fly.
However I want to store tuples in an incremental fashion so as to process
them in a batch approach in the finalaggr function. Think for example
implementing logistic regression (which is an OLAP query by its nature). I
want to support it with the current features that PostgreSQL provides from
which the closest feature is an aggregate. However an aggregate function
feeds me one a tuple for each call, but I would like to have access to a
batch of tuples per function call. Is there any possible way to perform
something like this?
Thank you very much for your time,
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ondrej Ivanič | 2012-11-29 21:25:07 | Re: About aggregates... |
| Previous Message | Mike Blackwell | 2012-11-29 21:03:47 | Enforcing minimum on many-to-many relationship? |