Re: Aggregate Functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yadnyesh Joshi <yadnyesh_joshi(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Aggregate Functions
Date: 2006-11-20 05:23:27
Message-ID: 22835.1164000207@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Yadnyesh Joshi <yadnyesh_joshi(at)yahoo(dot)com> writes:
> According to the documentation, when "avg" or "stddev" function is used wit=
> h integer arguments, the result is an integer.

Where do you think you read that?

regression=# create table foo(f1 int);
CREATE TABLE
regression=# insert into foo values(1);
INSERT 0 1
regression=# insert into foo values(2);
INSERT 0 1
regression=# insert into foo values(7);
INSERT 0 1
regression=# select avg(f1) from foo;
avg
--------------------
3.3333333333333333
(1 row)

regression=# select stddev(f1) from foo;
stddev
--------------------
3.2145502536643183
(1 row)

regression=#

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-20 05:43:35 Re: Aggregate Functions
Previous Message Yadnyesh Joshi 2006-11-20 05:05:24 Aggregate Functions