> Works just fine with 3.6.1 if you declare the Value column to be 
> INTEGER. As it is, I have no idea what collation is used, but the 
> Value column will be declared to default to TEXT values, as shown by
>
> select typeof(value) from test_table;
>
I haven't tried that, but I cannot declare it as INTEGER, because it 
contains strings as well (of course they're not selected to get min/max 
values). Would I need to write my own min/max functions to handle this?

Thanks,

  Dennis


P.S. Sorry for the message I sent to you personally - the Reply-to 
button is too smart :)

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to