> That, unfortunately, leads directly to the follow-up question of > "can BIGINT PRIMARY KEY AUTOINCREMENT" be made to work the same as > INTEGER PRIMARY KEY AUTOINCREMENT". I believe the answer is yes, but > I wouldn't bet my life on it.
If I knew anything at all about SQLite, I'd probably say the answer to that is something on the order of "How many other variations of 'INT' or 'INTEGER' would have to be implemented to be compatible with the plethora of other database systems out there? And why should SQLite be responsible for making sure it's interoperable with every single one of them? SQLite is SQLite, and no other." But then, I'm a jerk, so don't listen to closely to what I say. /bs _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
