On 3 Sep 2018, at 6:15pm, Sebastian
wrote:
> So is this the reason that the function doesn't exist? That it needs AS
> clauses to be useful?
More likely, that it is not needed by SQLite itself. sqlite3_column_name() is
used inside SQLite, but there's no need for your proposed function.
I am aware that this function would only work reliably if you use AS clauses.
But that's what I intend to do, so no problem. Sorry for not having mentioned
that.
So is this the reason that the function doesn't exist? That it needs AS clauses
to be useful?
Or the efficiency pitfall I suspected?
The name of an output column is not even defined, much less unique, unless the
author of the statement has done extra work (using unique column names and/or
AS clauses).
Consider
Select a.*,b.*,c.* ...
Where each table has a column named Id. Which index would you like to have
returned?
3 matches
Mail list logo