Jay A. Kreibich wrote, On 08/01/11 14:07: > 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 > Well so long as it _is_ a column name, just that it's not specified whether it will include tablename or alias then that's all that matters.
I interpreted Igor's reply to mean that unless the column name was specified by an AS in the projectors then that function could return anything, including garbage. -- Peter Hardman 'For every complex problem there is a solution that is simple, straightforward - and wrong' _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
