bug on aggregate function AVG() - Mailing list pgsql-hackers

From Jose' Soares
Subject bug on aggregate function AVG()
Date
Msg-id 363EBBDB.72566949@sferacarta.com
Whole thread Raw
List pgsql-hackers
prova=> select * from a;
int_2|     int_4|              int_8
-----+----------+-------------------
32767|2147483647|9223372036620802086
32767|2147483647|9223372036620802086
(2 rows)

prova=> select avg(int_2), avg(int_4), avg(int_8) from a;
avg|avg|       avg
---+---+-----------1| -1|-233973722
(1 row)


Jose'


pgsql-hackers by date:

Previous
From: dustin sallings
Date:
Subject: Re: [GENERAL] Upcoming 6.4 release issues
Next
From: "Jose' Soares"
Date:
Subject: Re: bug on aggregate function AVG()