On Wed, May 25, 2011 at 4:40 AM, Jan Hudec <b...@ucw.cz> wrote: > I need condition > > object_id = side_id & ~(1 << 63) > > but that's not valid syntax. >
Yeah it is. Try, for example: SELECT 1234 & ~(1<<63); SELECT (-1234) & ~(1<<63); -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users