Hello out there,
an ignorant's question: can I/how can I create an aggregate that
performs this operation on a group of timestamp values:
select some_column,
min(timest)+(max(timest)-min(timest))/2
from mytable
group by some_column;
that is, an aggregate which calculates the point half way between the
minimum and the maximum of the time series? I would like to use it
like this (substitute something appropriate for "median", I don't have
an idea how to call it):
select some_column, median(timest)
from mytable
group by some_column;
Any suggestions appreciated!
Regards,
Ulf
--
=======================================================================
Ulf Mehlig <[EMAIL PROTECTED]>
Center for Tropical Marine Ecology/ZMT, Bremen, Germany
-----------------------------------------------------------------------
