Skip site navigation (1) Skip section navigation (2)

AVG function

From: rodneyr(at)embratel(dot)com(dot)br
To: pgsql-interfaces(at)hub(dot)org
Subject: AVG function
Date: 1999-08-28 15:09:39
Message-ID: 032567DB.00534444.00@ntrjo008.nt.embratel.com.br (view raw or flat)
Thread:
Lists: pgsql-interfaces
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.



Responses

pgsql-interfaces by date

Next:From: Hannu KrosingDate: 1999-08-28 15:48:35
Subject: Re: [INTERFACES] AVG function
Previous:From: Gerardo Fdez. NavarreteDate: 1999-08-28 14:54:52
Subject: how to unsubcribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group