Igor Tandetnik <[email protected]> wrote: > If the values of b, c and so on have a known upper bound, then you can write > something like > > select min(a*1000 + b), min(a*1000 + c), ..., min(a*1000 + f) from v;
I mean, select min(a*1000 + b) % 1000, ... or the same with shifts and masks: select min(a<<32 + b) & 4294967296, ... -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
