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@xxxxxxxxxxx
