https://www.sqlite.org/datatype3.html#comparison_expressions has the rules
for how values of different types are ordered and when type conversions
automatically happen.
Numbers are always less than strings, so in that example you should be
using round() instead of printf() as you discovered.
On
Hi all,
I was wondering whether sqlite does type checking for fields which are
referenced in WHERE clause. Because when i tried to compare a field
generated by printf function and tried to compare it with a float value,
the comparison didn't work
Eg.
SELECT count.theme as theme,
2 matches
Mail list logo