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?
Yahoo! India Answers: Share what you know. Learn something new
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2006-11-20 05:23:27|
|Subject: Re: Aggregate Functions |
|Previous:||From: Tom Lane||Date: 2006-11-20 03:17:27|
|Subject: Re: CHECK constraint and trigger |