Hi!
I'm not sure if this is a bug, but it's sure unpleasant (for me).
(pseudocode)
create table t (a int2);
insert into t values (random number); <-- performed many, many times
now the following will return very unpredictable values:
select avg(a) from t;
while the following behaves as I would expect:
select avg(a::int4) from t;
I suppose avg() does a sum()/count() where sum returns a int2,
which will be too small to contain the sum if the table contains
many values?
Is this something I must know as a user, or is it a bug?
Regards,
Patrik Kudo
--
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!