On Fri, 26 May 2000, Norbert Meissner wrote:
> Hi all,
>
> i found a strange behaviour in Postgresql 7.0 on FreeBSD 4.0
>
> $ createdb foo
> $psql foo
> foo=# create table number (a_number int);
> foo=# insert into number values(1500000000);
> foo=# insert into number values(1600000000);
> select avg(a_number) from number;
> avg
> ------------
> -597483648
>
test=# select avg(a_number::int8) from number;
avg
------------
1550000000
(1 row)
The parser select function from column type. You use 'int' --- the parser
use avg(int4)....
Karel