Re: Statistical Lacunae in Interval type

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: David Fetter <david(at)fetter(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Statistical Lacunae in Interval type
Date: 2004-07-12 07:18:35
Message-ID: 200407120918.35775.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Fetter wrote:
> I just ran across this, and was wondering whether it's worth a
> back-patch.

New features are not back-patched.

> The interval type has an aggregate for average (AVG),
> but not one for standard deviation (STDDEV) or variance (VARIANCE).
>
> Is this a bug?

No, it's a missing feature. :-)

> Is there some problem with defining variance over
> intervals?

If all the operations that are used as part of the calculation of stddev
are available for intervals, then I don't see one.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2004-07-12 07:35:58 Re: Status report
Previous Message Christopher Kings-Lynne 2004-07-12 06:55:54 Re: Bug: psql misquotes constraints