Home > mailing lists

No stddev() for interval? - Mailing list pgsql-general

From	Brendan Jurd
Subject	No stddev() for interval?
Date	May 20, 2006 15:14:20
Msg-id	37ed240d0605200814y5dfbd443s9d6938dbf3bd9aa4@mail.gmail.com Whole thread Raw
Responses	Re: No stddev() for interval? (Tom Lane <tgl@sss.pgh.pa.us>) Re: No stddev() for interval? (David Fetter <david@fetter.org>)
List	pgsql-general

Tree view

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?

Regards,
BJ

pgsql-general by date:

From: kmh496
Date: 20 May 2006, 14:35:01
Subject: Re: another seemingly simple encoding question

From: Tom Lane
Date: 20 May 2006, 16:05:43
Subject: Re: No stddev() for interval?

No stddev() for interval? - Mailing list pgsql-general

Previous

Next