Re: [GENERAL] Postgresql for a CEP app

2010-09-29 Thread Leonardo Francalanci
> In pl/pgsql at any rate, functions which return a set of rows build up > the entire result set in memory and then return the set in one go: Ok, then pl/pgsql and pl/python (which can't return SETOF) are ruled out. (Thank you for pointing that out). But pl/perl seems to do the trick: "PL/Per

Re: [GENERAL] Postgresql for a CEP app

2010-09-29 Thread Raymond O'Donnell
On 29/09/2010 10:52, Leonardo Francalanci wrote: Hi, I need to generate aggregates of data coming from a stream. I could easily doing it inserting data coming from the stream into a table, and then query it using something like: select from atable group by The problem with this approach is

[GENERAL] Postgresql for a CEP app

2010-09-29 Thread Leonardo Francalanci
Hi, I need to generate aggregates of data coming from a stream. I could easily doing it inserting data coming from the stream into a table, and then query it using something like: select from atable group by The problem with this approach is that I would have to wait for the whole stream to