On 17 Jan 2012, at 11:01am, g...@novadsp.com wrote: > I've working on a location aware application that uses GUIDs as the primary > key for related tables. The SQLite R*Tree module is the natural choice for > indexing the image location data but there the issue of the integer primary > key type. > > Is it possible to change the primary key type? > Is it possible to add an additional column to the virtual table and retrieve > its value in a query?
Neither of those things are simple. Rather than hack an existing library, I recommend that you allow the R*Tree module to maintain its integer keys and make another (normal, not R*Tree) table in the same SQLite database to keep the list of GUIDs vs. integer keys. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users