Igor Tandetnik <itandetnik@...> writes:
> Jan Hudec <bulb@...> wrote:
> > (it would be nicest if sqlite could get bitwise not one day).
>
> -x-1 is equivalent, assuming two's complement representation.
Gotcha! No, it's not. -1-x is equivalent, but -x-1 is not:
sqlite> select -1-(1<<63), -(1<<63)-1;
9223372036854775807|9.22337203685478e+18
Besides my point was not that it's not possible, but that it would
be more readable with dedicated operator.
Regards,
Jan Hudec
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
