Hello! On Friday 12 March 2010 11:47:40 Ben Harper wrote: > Is there some recommended workaround that I can use to ensure that I always > get non-null rowids with every VIEW? > > CREATE TABLE one (i32 INTEGER); > INSERT INTO one VALUES(100); > INSERT INTO one VALUES(200); > CREATE VIEW v1 AS SELECT * FROM one; > CREATE VIEW v2 AS SELECT rowid,* FROM one; -- My current best guess
Do you have the ROWID column in the "one" table? No. But why you want to have it in the results of the "select * from one"? System columnt ROWID must be explicitly defined in all select. As example, PostgreSQL has a few system columns too and you may explicitly define these in your queries too. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users