Gerry Snyder wrote: > Scott Baker wrote: >> .... I didn't realize "INTEGER PRIMARY KEY" was case sensitive. Thanks > > Are you sure what you used before did not have a typo, or the words in a > different order?
Good question... must have been. Testing it: sqlite> CREATE TABLE foo (bar integer primary key); sqlite> EXPLAIN QUERY PLAN SELECT * FROM foo WHERE bar = 13; 0|0|TABLE foo USING PRIMARY KEY I must have typod and not noticed. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
