Re: seeming overflow during avg() of intervals without errors/warnings - Mailing list pgsql-general

From Vick Khera
Subject Re: seeming overflow during avg() of intervals without errors/warnings
Date
Msg-id CALd+dcdBPHWsRPecXCEpTD_tyVtFbGsk5aAwy3Jub8v+g3JKYw@mail.gmail.com
Whole thread Raw
In response to Re: seeming overflow during avg() of intervals without errors/warnings  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, May 15, 2013 at 10:50 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Somebody ought to fix that.

A larger question is whether it'd be worth the trouble for interval
avg() to use some wider internal representation so it could avoid
the overflow.  Given the lack of prior complaints I'm inclined to
suspect it's not.


Should I file a formal bug report? Personally, I care not either way it is fixed, but I never want to get garbage answers.

Thanks for looking into it.

pgsql-general by date:

Previous
From: Serge Fonville
Date:
Subject: Re: Foreign Key violated
Next
From:
Date:
Subject: Re: [PERFORM] Very slow inner join query Unacceptable latency.