On 9/22/2014 4:08 PM, jungle Boogie wrote:
Hi Igor,
On 22 September 2014 12:52, Igor Tandetnik <i...@tandetnik.org> wrote:
Dollar sign or not, the outcome you observe suggests that the values are
stored as strings. What does this query return?
select typeof(transaction_amount), count(*) from august group by 1;
My guess is that most, if not all, rows would report
typeof(transaction_amount) as 'text'.
typeof(transaction_amount)count(*)
text 135388
Just as I thought. You are storing your values as text - not as numbers
- and comparing them accordingly, in alphabetical order.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
