Re: No stddev() for interval?

"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