Postgres Pro
Downloads
Home   >   mailing lists

Aggregate Functions - Mailing list pgsql-novice

From Yadnyesh Joshi
Subject Aggregate Functions
Date
Msg-id 20061120050524.39259.qmail@web53207.mail.yahoo.com
Whole thread Raw
Responses Re: Aggregate Functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Aggregate Functions  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: Aggregate Functions  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-novice
Tree view
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.

Find out what India is talking about on - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: CHECK constraint and trigger
Next
From: Tom Lane
Date:
Subject: Re: Aggregate Functions