Panos Kassianidis wrote:
Thanks very much for the answer.
Could you also please tell me how am I supposed to write such a function?
How is date_trunc implemented so that I can extend it? In C in SQL?
I'd probably write it in plpgsql unless you need the speed.
And where can I find its source c
Panos Kassianidis wrote:
and I would like to retrieve values recorded in the last 2 hours but
with an interval of 5 minutes, which means that my query should return
one tuple for every 5 tuples in the table and the value of this tuple
should be an average of 5 values.
Does anyone have any clue ho
