On 30 Jan 2011, at 11:34am, Lapo Luchini wrote: > Column headers are different if obtained from a table or a view:
Yep. The column headers are defined very precisely for columns retrieved directly from a table. For anything else, they're not defined very clearly. Try looking at the column headers for functions, for example. SELECT rowid, abs(rowid) FROM myTable Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

