bug on aggregate function AVG()

From: "Jose' Soares" <jose(at)sferacarta(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: bug on aggregate function AVG()
Date: 1998-11-03 08:16:27
Message-ID: 363EBBDB.72566949@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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'

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jose' Soares 1998-11-03 08:21:05 Re: bug on aggregate function AVG()
Previous Message dustin sallings 1998-11-03 06:22:44 Re: [GENERAL] Upcoming 6.4 release issues