avg() bug? - Mailing list pgsql-general

From Patrik Kudo
Subject avg() bug?
Date
Msg-id Pine.BSF.4.31.0103051750060.976-100000@tb303.partitur.se
Whole thread Raw
Responses Re: avg() bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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å!


pgsql-general by date:

Previous
From: "mike"
Date:
Subject: name vs text vs varchar
Next
From: Limin Liu
Date:
Subject: chinese_big5 for PgAccess