On 13 Nov 2009, at 9:11pm, Kees Nuyt wrote: > SELECT rowid AS rowid, col1, col2 > FROM foo; > rowid|col1|col2 > 1|1|row1 > 2|2|row2
Heh. Neat. Also you can do things like SELECT col1 AS rowid, col1, col2 Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users