Statistical Lacunae in Interval type

From: David Fetter <david(at)fetter(dot)org>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Statistical Lacunae in Interval type
Date: 2004-07-12 06:11:52
Message-ID: 20040712061152.GB23679@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kind people,

I just ran across this, and was wondering whether it's worth a
back-patch. The interval type has an aggregate for average (AVG), but
not one for standard deviation (STDDEV) or variance (VARIANCE).

Is this a bug? Is there some problem with defining variance over
intervals?

TIA for any pointers in the right direction...

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2004-07-12 06:31:09 Re: Bug: psql misquotes constraints
Previous Message Tom Lane 2004-07-12 02:45:22 Re: Is the time zone comment in postgresql.conf still valid?