Quoting Dennis Cote ([EMAIL PROTECTED]):
> In SQLite I get the following:
>
> SQLite version 3.3.2
> Enter ".help" for instructions
> sqlite> create table t (a integer, b real);
> sqlite> insert into t values (3, 3);
> sqlite> insert into t values (3, 3);
> sqlite> insert into t values (4, 4);
> sqlite> select avg(a), avg(b) from t;
> 3.33333333333333|3.33333333333333
In PostgreSQL 7.3, I get the same:
cosdb=> create table t (a integer, b real);
CREATE TABLE
cosdb=> insert into t values (3, 3);
INSERT 973963 1
cosdb=> insert into t values (3, 3);
INSERT 973964 1
cosdb=> insert into t values (4, 4);
INSERT 973965 1
cosdb=> select avg(a), avg(b) from t;
avg | avg
--------------------+------------------
3.3333333333333333 | 3.33333333333333
(1 row)
cosdb=>
--
Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/
Make backups before you try something new or interesting or experimental
or radical or if the day has a "y" in it.
-- Chris Hacking
