On Tue, Aug 31, 2010 at 9:07 AM, Eric Smith <eas....@gmail.com> wrote:

>
> You probably don't want 'SELECT max(foo_id)+1' because I think that does
> a full table scan.
>
>
you're right, but slightly modified version SELECT (SELECT max(foo_id) FROM
MxVft_FTIndex)+1 does not

Max
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to