On Mon, Feb 11, 2013 at 2:52 PM, Michael Black <[email protected]> wrote:
> Probably because you're storing your numbers as text. How are you > inserting > them? > Do a .dump from the shell and you'll see it in the record dump. > > So '7' > '20' but 7 < 20 > Indeed, i just added type affinities to the schema and it now behaves as i would expect. Thank you (and Richard) for the tip! -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
