On 10 Mar 2014, at 11:57am, Stephan Beal <[email protected]> wrote:
> The remaining questions: > > - How are view selects handled differently than table selects? > - If so, then what is the reasoning behind it? > > This is not explained, but it's quite possibly that way so that the > implementation has some leeway in how it works. In other words, the strings returned are just whatever the developers found handy when they wrote the code. They're not defined by the SQL standard, and they're undocumented, so nobody cares what they are. To make it even clearer, they may work differently in different versions of SQLite. In other words, even if you get your program working perfectly with the column names returned by one version of SQLite, a later update may change what the column names are, and the developers won't consider this a bug. So if you want column names to be something useful, use AS in your command. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
