Skip site navigation (1) Skip section navigation (2)

Problems with avg on interval data type

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problems with avg on interval data type
Date: 2001-05-17 19:24:39
Message-ID: 200105171924.f4HJOdh29914@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Jeremy Blumenfeld (jeremy(at)horizonlive(dot)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


Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-05-17 19:25:20
Subject: Re: [COMMITTERS] pgsql/ oc/src/sgml/runtime.sgml rc/backend/uti ...
Previous:From: Tom LaneDate: 2001-05-17 18:54:00
Subject: Re: [COMMITTERS] pgsql/ oc/src/sgml/runtime.sgml rc/backend/uti ...

pgsql-bugs by date

Next:From: Krzysztof GajdemskiDate: 2001-05-18 14:20:24
Subject: "Unvisible" duplicates in SELECT [...] HAVING count(attrib) > 1
Previous:From: Tom LaneDate: 2001-05-17 18:29:58
Subject: Re: pqReadData() -- backend closed the channel unexpectedly.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group