Re: Aggregate Functions

> 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.

It looks to me that is already does:

mydb=> \d+ test;
                       Table "public.test"
 Column  |            Type             | Modifiers | Description
---------+-----------------------------+-----------+-------------
 id_i    | integer                     | not null  |
 ir_id   | integer                     | not null  |
 test    | boolean                     |           |
 stamp   | timestamp without time zone |           |
 inttest | integer                     |           |
Indexes:
    "test_pk" PRIMARY KEY, btree (id_i, ir_id)
Has OIDs: no

mydb=> select * from test limit 5;
 id_i | ir_id | test |        stamp        | inttest
------+-------+------+---------------------+---------
    1 |     9 | f    | 2006-06-19 04:30:00 |       0
    1 |    10 | f    | 2006-06-19 05:30:00 |       0
    1 |     3 | t    | 2006-06-05 03:00:00 |       1
    2 |     4 | t    | 2006-06-05 04:00:00 |       1
    3 |     6 | t    | 2006-06-05 06:00:00 |       1
(5 rows)

mydb=> select avg(id_i) from test;
         avg
---------------------
 37.5679012345679012
(1 row)

mydb=> select stddev(id_i) from test;
       stddev
---------------------
 23.3285974029756760
(1 row)

Regards,

Richard Broersma Jr.