function ave(integer) does not exist

Hi All,

This one is confusing. The only difference in my db is that it comes from a
user specific template not pg_default.

I run this:

***********************************************************************************************************************************************************
create temp table test (var int);
insert into test (var) values
(1), (2), (3), (4), (5), (6), (243);

select ave(var)
from test;
***********************************************************************************************************************************************************

and I get this as the error:

***********************************************************************************************************************************************************
ERROR: function ave(integer) does not exist
LINE 1: select ave(var)
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.

********** Error **********

ERROR: function ave(integer) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need
to add explicit type casts.
Character: 8
***********************************************************************************************************************************************************

So why is this happening? I can run a "select sum(var)" and it works.

Thanks,
~Ben