On 27 Mar 2011, at 7:17pm, Darren Duncan wrote:

> Simon Slavin wrote:
>> I forgot a bunch of functions.  You need to be able to do comparisons, so you
>> can determine whether one decimal is greater, less or equal to another.  And
>> users will want abs(), max(), min(), round(), avg(), sum(), and total().
> 
> What is this "total" function you speak of and how does it differ from "sum"?

http://www.sqlite.org/lang_aggfunc.html

> Also, it's better to call a function "mean" than "avg" if that's what is 
> intended, since there are other kinds of averages like "median" and "mode".

Sorry, it's in the Standard that way.  See, for example,

http://www.postgresql.org/docs/9.0/static/functions-aggregate.html

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to