In the case of PostgreSQL, avg is actually returning numeric when handed an int.
On Wed, Feb 08, 2006 at 11:26:37AM -0800, Rich Shepard wrote: > On Wed, 8 Feb 2006, Paul Tomblin wrote: > > >In PostgreSQL 7.3, I get the same: > > Also in postgres-8.1.2. I entered the reals with a decimal point; made no > difference. > > Rich > > -- > Richard B. Shepard, Ph.D. | Author of "Quantifying > Environmental > Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy > Logic" > <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: > 503-667-8863 > -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
