On Sat, Jan 08, 2011 at 09:12:36AM +0000, Simon Slavin scratched on the wall: > > On 8 Jan 2011, at 9:09am, Peter wrote: > > > So the 'column name' may be some internal representation/magic number > > and bear no direct relationship to the name in the projector as supplied > > in the SELECT? > > For columns which are exact copies of columns in a table, the name > is always a copy of the table's column name. You can rely on that.
Unless the name is prefixed with a table name. Or unless the name is prefixed with a table alias (AS in a FROM clause). I wouldn't even be surprised to find version that prefix database names, when appropriate. You can rely on "AS" names, and that's pretty much it-- just as the docs warn. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
