On Sunday 26 March 2006 04:33 pm, Tony Smith wrote:
> Hi everyone:
>
> We have the max function in postgresql so we can run
> something like:
>
> select max(my_field) from my_table?
>
> But I can not find a mean function. Can we do:
>
> select mean(my_data_field) from my_table?
>
select avg(my_data_field) from my_table
http://www.postgresql.org/docs/8.1/interactive/functions-aggregate.html
--
Adrian Klaver
aklaver(at)comcast(dot)net