Is there any possibility that in a future version of SQLite, pragma table_info or some other pragma could return a simple boolean "this column is the rowid" indicator? As demonstrated under "Goofy Behavior Alert" at http://www.sqlite.org/lang_createtable.html#rowid it is possible (if unlikely) for a column to appear as type='INTEGER' and pk=1 in the pragma table_info results and yet *not* be the rowid. This is an annoyance that could easily be solved simply by letting SQLite communicate its own determination about the column back to the user.
Thanks, Andrew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
