There is already such a feature request at: http://www.sqlite.org/cvstrac/tktview?tn=2604
I just added a patch there which, I believe, implements this. I'm going to float it on sqlite-dev to see if I'm missing anything. -scott On Wed, Aug 27, 2008 at 9:20 AM, Petite Abeille <[EMAIL PROTECTED]> wrote: > Hello, > > On Aug 26, 2008, at 11:34 PM, Dennis Cote wrote: > >> Petite Abeille wrote: >>> >>> Is it possible to use 'if not exists' in conjunction with the >>> creation >>> DDL for a virtual table? >>> >> >> No, its not possible. >> >> The syntax of a "create table" statement is shown here >> http://www.sqlite.org/lang_createtable.html and that for a "create >> virtual table" statement is shown here >> http://www.sqlite.org/lang_createvtab.html. The virtual table >> statement >> does not allow the optional "if not exists" clause. > > Hmmm... bummer... any reason for such discrepancy? This 'if not > exists' clause is rather handy :) > > Is there a place where one could raise a feature request for such > functionality? > > Thanks in advance. > > Cheers, > > -- > PA. > http://alt.textdrive.com/nanoki/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users