Great reply! The column name management seems to be an ongoing issue. It would be nice to see it finally put to rest. Conforming to either the standard(?) or common practice makes the most sense to me. At least it is not a multi user issue that was not designed for in the first place :-)
Fred -----Original Message----- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 8:37 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Trouble with column names On Mon, 2005-04-25 at 15:12 +0300, George Ionescu wrote: > sqlite3 test.db > create table test(Field1 text(20)); > insert into test values ('a value'); > select field1 from test; > Please tell me what *you* think the column name should be in the following cases. Also, please tell me what PostgreSQL and MySQL and perhaps Oracle do. The decision of how to name result columns is complex and I am unwilling to go about making random changes here and there in whack-a-mole fashion. Until there is a specification on what column names should actually be, I will decline to change anything. ...
