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@michvhf.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
==========================================================================