So far no one has raised the idea of using a "big int" layer to implement proper integer arithmetic past 64 bits. The fact that it hasn't been mentioned makes me worry that it's a blatantly silly idea for SQLite for some reason -- but I'm tossing it out there on the off chance that it's useful.
Personally, I would have loved to be able to use 128-bit integer math a few weeks ago when I was investigating the idea of implementing a longest-prefix search capability for IPv6 networks using SQLite's R*Tree. I had to implement all the shifting and such in C, which is fine, but it would have been pretty sexy to have gotten it all done in SQL. Eric _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
