Le Hyaric Bruno <bruno.le-hya...@fr.thalesgroup.com> wrote: > My wish is to be able to select an item like that : > > $SELECT id FROM item WHERE bits & 1<<'X'; > (where X is a random value from 0 to 200000...)
If you go custom function route for this, you may benefit from incremental blob API - see http://sqlite.org/c3ref/blob_open.html http://sqlite.org/c3ref/blob_read.html This would allow you to check individual bits (well, bytes) without having to read the whole blob into memory. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users