Re: No stddev() for interval?

From: David Fetter <david(at)fetter(dot)org>
To: Brendan Jurd <direvus(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: No stddev() for interval?
Date: 2006-05-20 20:28:28
Message-ID: 20060520202828.GA27076@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2006-05-20 21:27:46 Re: No stddev() for interval?
Previous Message John DeSoi 2006-05-20 19:51:25 Re: Best practice to grant all privileges on all bjects in database?