On Sun, May 21, 2006 at 01:14:15AM +1000, Brendan Jurd wrote:
> Hi all,
>
> I noticed a peculiarity in the default postgres aggregate functions. min(),
> max() and avg() support interval as an input type, but stddev() and
> variance() do not.
>
> Is there a rationale behind this, or is it just something that was never
> implemented?
That's because variance of foo is measured in foo^2 units. What is
the square of an interval?
Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!