Patrik Nilsson <nipatriknils...@gmail.com> wrote: > When I perform a select as the following > > select * from repetition where interval>0 and id=617 > > the result is unexpected > > 617|2012-12-23 19:30:46|0|2012-12-23 19:30:46|0|1|1|0
My educated guess is, interval column has a string value '0' in this row, not a numeric value 0. All strings compare greater than all numbers. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
