Re: [sqlite] How do bitwise operators work? - Example of schema and request

Le Hyaric Bruno 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 20...) If you go custom function route for this, you may benefit from incremental blob API -

Re: [sqlite] How do bitwise operators work? - Example of schema and request

>Can you provide examples of your schema, data, and the types of queries > you want to run? This would make it easier to offer suggestions. > > Rich Of course Richard, In my test I was simply doind something like that : $sqlite3.exe test.db $CREATE TABLE item(id INTEGER PRIMARY KEY