Am 20.02.2008 um 11:54 schrieb Jos van den Oever: > Hi all, > > Is it possible to use logic operations on fields, in particular on > integers and on fixed sized blobs (256 bits/32 bytes). > I'd like to do queries like this: > select key where number_of_bits_set(value) = 10;
I believe for this kind of query you'll have to implement a user function - see <http://www.sqlite.org/capi3ref.html#sqlite3_create_function > for details. > > or > select key where value & '010110000....'; You can use bit-wise AND and OR operations on integers. Not sure about BLOBs, though... If it doesn't work out of the box, implement a user function. HTH, </jum> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
