Postgres Pro
Downloads
Home   >   mailing lists

Statistical Lacunae in Interval type - Mailing list pgsql-hackers

From David Fetter
Subject Statistical Lacunae in Interval type
Date
Msg-id 20040712061152.GB23679@fetter.org
Whole thread Raw
Responses Re: Statistical Lacunae in Interval type  (Peter Eisentraut <peter_e@gmx.net>)
Re: Statistical Lacunae in Interval type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is the time zone comment in postgresql.conf still valid?
Next
From: Greg Stark
Date:
Subject: Re: Bug: psql misquotes constraints