Hello! On Monday 14 December 2009 11:33:32 Jens Miltner wrote: > ...
You did not understand me. The manually named columns may not be renamed automatically. But in the test the column "id" was renamed to "id:1": sqlite> create table test (id INTEGER PRIMARY KEY); sqlite> insert into test default values; sqlite> create view view_test as select rowid,'I am "id" field!' as id from test; sqlite> .header on sqlite> select * from view_test; id|id:1 1|I am "id" field! The construction 'I am "id" field!' as id _must_ return the column as "id" column. Any other result is wrong. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
