On Fri, Apr 29, 2011 at 3:37 AM, Simon Slavin <[email protected]> wrote:
> The thing is, there's not problem with referring to rowid, or ROWID or any > of the other aliases when you do this. The only problem is possible > confusion for the programmer if you define a column with one of these names > which /isn't/ an alias to SQLite's internal row numbers. And it's just > programmer confusion: if you know exactly how SQLite handles this then it's > fine. > Another subtle problem/confusion point is that: select * ...; will not return 'rowid' unless it is explicitly declared or you do this: select rowid, * ... e.g.: sqlite> select * from whiki_page_tag; eek|tag1| eek2|tag1| eek|tag2| sqlite> select rowid,* from whiki_page_tag; 1|eek|tag1| 2|eek2|tag1| 3|eek|tag2| -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
