SQLite total vs sum
t.heaford at icloud.com
Sun Jul 5 09:02:24 CEST 2015
Thanks for your observations. Will stick with total() for now.
All the best
> 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