Postgres Pro
Downloads
Home   >   mailing lists

Problems with avg on interval data type - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Problems with avg on interval data type
Date
Msg-id 200105171924.f4HJOdh29914@hub.org
Whole thread Raw
Responses Re: Problems with avg on interval data type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Jeremy Blumenfeld (jeremy@horizonlive.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Problems with avg on interval data type

Long Description
We have recently upgraded from 7.0.3 to 7.1 and a query which used to work is no longer working.
The query does an avg on an interval column and now gets the error:

ERROR:  Bad interval external representation '0'

We've reproduced this problem with other tables using an interval type.  It can handle count, sum, but not avg.

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pqReadData() -- backend closed the channel unexpectedly.
Next
From: Krzysztof Gajdemski
Date:
Subject: "Unvisible" duplicates in SELECT [...] HAVING count(attrib) > 1