Re: [HACKERS] 6.5.0 - Overflow bug in AVG( )

On Wed, 16 Jun 1999, [iso-8859-1] Jos Soares wrote:

> PostgreSQL:
> ^^^^^^^^^^^
> prova=> select min(a), max(a), avg(a) from aa;
> min|max|avg
> ---+---+---
> 1| 2| 1
> (1 row)
>
>

Sybase - I'm guessing/ass-u-me ing it's around version 4.9

1> select min(a), max(a), avg(a) from aa
2> go

----------- ----------- -----------
1 2 1

(1 row affected)
1>

> > This would seem to give license for the result of AVG() on an int4 field
> > to be NUMERIC with a fraction part, but not FLOAT. But I suspect we
> > could get away with making it be FLOAT anyway. Anyone know what other
> > databases do?

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================