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@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
