Can this be done with sql?

Поиск
Список
Период
Сортировка
Искать
От
teknokrat@yahoo.com (teknokrat)
Тема
Can this be done with sql?
Дата
Msg-id
1cbae208.0207031032.7d1be1a2@posting.google.com
Список
Дерево обсуждения
Re: Can this be done with sql? teknokrat@yahoo.com (teknokrat)
Re: Can this be done with sql? "Rajesh Kumar Mallah." <mallah@trade-india.com>
In my database i have values recorded in one minute intervals. I would
like a query that can get me results for other time intervals. For
example - return maximum value in each 3 minute interval. Any ideas
how i can do this with sql? I tried writing a procedure in plsql but i
am told it does not support tuples as output. I can get the all the
one minute intervals and process them to get me three minute intervals
in my application but i would rather not do the expensive call for the
one minute intervals in the first place due to the large number of
data. any ideas?

thanks



В списке pgsql-sql по дате отправления
От: srikanth
Дата:
Сообщение: how to write procedures
От: Bruce Momjian
Дата:
FAQ