"Ivan Zolotukhin" <ivan.zolotukhin@xxxxxxxxx> writes: > On 5/20/06, Tom Lane <tgl@xxxxxxxxxxxxx> 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
