On 07/01/11 18:41, Igor Tandetnik wrote: > On 1/7/2011 1:31 PM, Peter wrote: >> In the C interface documentation we are told: >> >> "The name of a result column is the value of the "AS" clause for that >> column, if there is an AS clause. If there is no AS clause then the name >> of the column is unspecified and may change from one release of SQLite >> to the next." >> >> What exactly is meant by 'unspecified'? > > Generated by internal logic that is not precisely documented, and is > subject to change without notice; should be treated as unpredictable, > and not relied on for anything of substance. > >> Does it mean that in the absence >> of an "AS" clause I will get either TABLE.COLUMN or COLUMN, or are >> there/may there be other alternatives? > > There may potentially be other alternatives, now or in the future.
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? Not a very useful function then. -- 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
