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: | Raw Message | Whole Thread | 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? |