Re: R: R: [GENERAL] complex custom aggregate function

2009-02-02 Thread Scara Maccai
Paolo Saudin wrote: > I use a master table with a "fulldate" field and filled with sequential dates > to > fill gaps when meteo data is missing. I'm sorry, I still don't get it: how can you be sure that postgresql won't call perl_sliding_mean with not-ordered timestamps-data? I don't mean only

R: R: [GENERAL] complex custom aggregate function

2009-02-02 Thread Paolo Saudin
>-Messaggio originale- >Da: pgsql-general-ow...@postgresql.org >[mailto:pgsql-general-ow...@postgresql.org] Per conto di Scara Maccai >Inviato: lunedì 2 febbraio 2009 10.36 >A: Paolo Saudin; pgsql-general@postgresql.org >Cc: pgsql-general >Oggetto: Re: R: [GE

Re: R: [GENERAL] complex custom aggregate function

2009-02-02 Thread Scara Maccai
> Paolo Saudin wrote: > For that purpose, a sliding mean calculation I use the following > > CREATE TABLE tbl_ayas > ( > fulldate timestamp without time zone NOT NULL, > id_1 real, -- temperature > id_2 real, -- pressure > .. > CONSTRAINT tbl_ayas_pkey PRIMARY KEY (fulldate) > )

R: [GENERAL] complex custom aggregate function

2009-02-01 Thread Paolo Saudin
>-Messaggio originale- >Da: pgsql-general-ow...@postgresql.org >[mailto:pgsql-general-ow...@postgresql.org] Per conto di Scara Maccai >Inviato: venerdì 30 gennaio 2009 9.36 >A: pgsql-general@postgresql.org >Oggetto: [GENERAL] complex custom aggregate function > >Hi all, > >I have a table l