Re: [sqlite] aggregate and index.

2012-01-10 Thread Richard Hipp
On Tue, Jan 10, 2012 at 12:56 PM, trash Spam wwwtrashs...@gmail.com wrote: Hi, Simplified example : Table t1 ( col1number primary key ,col2varchar( 50 ) ,col3number ) select min( col3 ) fro t1 ; explain plan : orderfromdetail 00

Re: [sqlite] aggregate and index.

2012-01-10 Thread trash Spam
2012/1/10 Richard Hipp d...@sqlite.org On Tue, Jan 10, 2012 at 12:56 PM, trash Spam wwwtrashs...@gmail.com wrote: SELECT (SELECT min(col3) FROM t1)+1; Works, thank you. sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users