R: R: [GENERAL] complex custom aggregate function

-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: [GENERAL] complex custom aggregate

Re: R: [GENERAL] complex custom aggregate function

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) ) WITH

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

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 in

R: [GENERAL] complex custom aggregate function

-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 like: