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
==========================================================================