The console output below indicates that 'if not exists' clause is
unsupported for virtual tables. Is this a bug, oversight or by design?
sqlite> CREATE VIRTUAL TABLE if not exists gps_index USING
rtree(id,minX,maxX,minY,maxY);
Error: near "not": syntax error
Many thanks.
Using SQLite version 3.7.7.1 built with SQLITE_ENABLE_RTREE=1 (Windows
7x64U/VS2008)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users