Balaji Ramanathan wrote: > I have some columns repeated multiple times, and I find that > some of the repeated columns have postfixes like ":52449101", > ":3016716403", ":197485499", ":3551085770", etc. Where do these postfixes > come from?
SQLite adds a number to make the name unique. After three tries, to speed up the search, it uses random numbers instead. > can I predict what the column names in the resulting output will be? No. Igor already told you: > Don't use "select *" in the view. Explicitly select columns you need, > assign aliases to them as needed. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users