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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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