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