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

Aggregate Functions

From: Yadnyesh Joshi <yadnyesh_joshi(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Aggregate Functions
Date: 2006-11-20 05:05:24
Message-ID: 20061120050524.39259.qmail@web53207.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
According to the documentation, when "avg" or "stddev" function is used with integer arguments, the result is an integer. How can I obtain floating point result (for more accuracy) while using "avg" or "stddev" function on integer arguments?
Thank you,
Yadnyesh.




		
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-11-20 05:23:27
Subject: Re: Aggregate Functions
Previous:From: Tom LaneDate: 2006-11-20 03:17:27
Subject: Re: CHECK constraint and trigger

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