| From: | "Steffen Macke" <sdteffen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2767: Bug in avg(interval) |
| Date: | 2006-11-18 07:17:51 |
| Message-ID: | 200611180717.kAI7Hpcd071631@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2767
Logged by: Steffen Macke
Email address: sdteffen(at)gmail(dot)com
PostgreSQL version: 8.1.4
Operating system: Windows XP
Description: Bug in avg(interval)
Details:
select avg(interval) is occasionally returning wrong
values:
Example:
select avg(test) from problem
returns
1 day 25:15:30
while the correct result is
2 days 01:15:30
Here is a table with sample data used:
CREATE TABLE problem (
test interval
);
COPY problem (test) FROM stdin;
1 day 20:39:28
4 days 00:02:53
1 day 00:03:01
2 days 02:08:34
01:33:34
3 days 07:05:35
\.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikko Tiihonen | 2006-11-19 02:00:58 | BUG #2768: dates before year 1600 in timestamptz column give strange results |
| Previous Message | Karl DeBieechop | 2006-11-17 21:23:02 | BUG #2766: erratic segfault in libpq/DBD::Pg |