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 <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
