On 9 Jul 2017, at 12:53am, petern <peter.nichvolo...@gmail.com> wrote:
> Is there some sort of easter egg there? Is there a way for VALUE to take
> the first row exclusively as column names? Perhaps there is a trick with
> other special characters?
The thing you’re doing does not have columns, just values. Consider what this
would mean:
SELECT * FROM (VALUES (0),(1,2),(3,4,5),(6,7,8,9));
Should this be valid SQL syntax ? If so, how many columns does the third row
have, and why ?
Although the shell tool is showing names because it’s expecting a table of
results, you shouldn’t depend on them, and the next version of SQLite might
pick other names. If you want columns to have names, create a TABLE or VIEW,
and specify what those names should be using "AS".
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
