Re: [sqlite] create table if not exists & virtual table?
On Aug 28, 2008, at 11:39 PM, Scott Hess wrote: > 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. Nice :) Hope to see this patch included in a future release as it's a rather convenient syntax. 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
Re: [sqlite] create table if not exists & virtual table?
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
Re: [sqlite] create table if not exists & virtual table?
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
Re: [sqlite] create table if not exists & virtual table?
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. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users