Richard Hipp <drh@...> writes:
>
> On Wed, May 25, 2011 at 4:40 AM, Jan Hudec <bulb@...> 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);
Wow, thanks. It's really strange that I didn't notice, because I
was looking for it when I wrote the code last year (using sqlite
3.6.20 back then and the operator is mentioned to exist since
long before version 3).
Best regards,
Jan
--
Jan Hudec <b...@ucw.cz>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
