| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Krzysztof Gajdemski | 2001-05-18 14:20:24 | "Unvisible" duplicates in SELECT [...] HAVING count(attrib) > 1 |
| Previous Message | Tom Lane | 2001-05-17 18:29:58 | Re: pqReadData() -- backend closed the channel unexpectedly. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-05-17 19:25:20 | Re: [COMMITTERS] pgsql/ oc/src/sgml/runtime.sgml rc/backend/uti ... |
| Previous Message | Tom Lane | 2001-05-17 18:54:00 | Re: [COMMITTERS] pgsql/ oc/src/sgml/runtime.sgml rc/backend/uti ... |