SQLite total vs sum

Terence Heaford t.heaford at icloud.com
Sun Jul 5 03:02:24 EDT 2015


Thanks for your observations. Will stick with total() for now.

All the best

Terry

> On 4 Jul 2015, at 17:18, Peter Haworth <pete at lcsql.com> wrote:
> 
> I lot depends on your application and whether you might want to move to
> another SQL implementation in the future.  If you think you might move, I
> would define a default value of zero for the columns you plan on summing
> and use (sum).  That still leaves the issue of integer overflow but you can
> probably work out if that is likely to be an issue for your application.
> 
> If you're 100% sure you won;t move to another SQL implementation, I'd go
> with total().




More information about the use-livecode mailing list