Re: [BUGS] Aggregate Function (AVG) not calculated correctly

2000-12-05 Thread Tom Lane
[EMAIL PROTECTED] writes: > I have included all code needed to prove the bug, No, you haven't: where are the table declarations? But I'll take a guess anyway: you declared "distance" as int2, didn't you? AVG(int2) currently uses an int2 accumulator, and you're suffering overflow. Try "AVG(dist

Re: [BUGS] Aggregate Function (AVG) not calculated correctly

2000-12-05 Thread Thomas Lockhart
[EMAIL PROTECTED] wrote: > > Gavin Evans ([EMAIL PROTECTED]) reports a bug with a severity of 1 > The lower the number the more severe it is. > > Short Description > Aggregate Function (AVG) not calculated correctly > > Long Description > Using the following code: > SELECT airline_code, AVG(dis