Hello,

Is it possible to use 'if not exists' in conjunction with the creation  
DDL for a virtual table?

For example:

create table if not exists document( content text )

vs.

create virtual table if not exists document using fts3( content text )

The first statement works as advertise, but the second one fails with  
a syntax error:

SQL error: near "not": syntax error

What gives?

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

Reply via email to