Received: from gatekeeper2.embratel.com.br ([200.255.122.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA66128
	for <pgsql-interfaces@hub.org>; Sat, 28 Aug 1999 11:08:38 -0400 (EDT)
	(envelope-from rodneyr@embratel.com.br)
From: rodneyr@embratel.com.br
Received: by gatekeeper2.embratel.com.br; (8.8.8/1.3/10May95) id MAA09742;
	Sat, 28 Aug 1999 12:12:45 -0300 (EST)
Received: from somewhere by smtpxd
Received: from somewhere by smtpxd
X-Lotus-FromDomain: EMBRATEL
To: pgsql-interfaces@hub.org
Message-ID: <032567DB.00534444.00@ntrjo008.nt.embratel.com.br>
Date: Sat, 28 Aug 1999 12:09:39 -0300
Subject: AVG function
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline

I'm using the AVG function to get the average of some integer values of my
database,
but the result is comming in the integer format too, and I'm loosing some
precision.

Does someone know how to get the result of the AVG function in a float type,
without
changing the structure of my table?

Thanks,

Rodney.