Re: No stddev() for interval?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: No stddev() for interval?
Дата
Msg-id 11541.1148142887@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: No stddev() for interval?  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
Ответы Re: No stddev() for interval?  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
Список pgsql-general
"Ivan Zolotukhin" <ivan.zolotukhin@gmail.com> writes:
> On 5/20/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Is it sensible to calculate standard deviation on intervals?  How would
>> you handle the multiple components?  I mean, you could certainly define
>> *something*, but how sane/useful would the result be?

> Strictly speaking there's nothing bad in intervals. Physically
> standart deviation on interval can be very useful without any doubts.

If the intervals are all expressed in seconds then sure, the calculation
is straightforward and useful.  I'm wondering what happens when nonzero
values of days and months get in there.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Ivan Zolotukhin"
Дата:
Сообщение: Re: No stddev() for interval?
Следующее
От: "Brendan Jurd"
Дата:
Сообщение: Re: No stddev() for interval?