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: (view raw or whole 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,

Yahoo! India Answers: Share what you know. Learn something new


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-2015 The PostgreSQL Global Development Group