select key where value & '010110000....';
Try:
select key where (value&176)
you need to convert the bit string to an integer number.
Also be aware that sqlite interperts numbers as signed 64 bit integer and this
can cause some issues with your bit mask number.
HTH.
Jos van den Oever <[EMAIL PROTECTED]> wrote: 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;
or
select key where value & '010110000....';
What would be a good method of implementing this?
Best regards,
Jos
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
