Re: bug on aggregate function AVG()

Jose' Soares wrote:
>
> 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'

The same on SUM():

prova=> select sum(int_2), sum(int_4), sum(int_8) from a;
sum|sum| sum
---+---+----------
-2| -2|-467947444
(1 row)

but it works as follow:

prova=> select avg(int_2*1.0), avg(int_4*1.0), avg(int_8*1.0) from a;
avg| avg|avg
-----+----------+-------------------
32767|2147483647|9.2233720366208e+18
(1 row)

prova=> select sum(int_2*1.0), sum(int_4*1.0), sum(int_8*1.0) from a;
sum| sum|sum
-----+----------+--------------------
65534|4294967294|1.84467440732416e+19
(1 row)

Jose'