On Tue, Feb 9, 2010 at 5:56 PM, Roger Binns <rog...@rogerbinns.com> wrote: > > Hamish Allan wrote: >> >> I'm sure there are ways you could work around the absence of >> "IF NOT EXISTS" in the simple "CREATE TABLE" case too. So why have the >> clause there? > > I assume because it is part of the SQL standard :-)
But the SQL standard does not mandate that if there is a CREATE VIRTUAL TABLE statement, that it must lack the IF NOT EXISTS clause, does it? ;) > They are also mangled as part of the release process, for example to include > version information. When I build from trunk, I use this: > > make TOP=. -f Makefile.linux-gcc sqlite3.c > > And then substitute the sqlite3.c into an amalgamation build. (Not quite > but conceptually the same.) Note that Makefile.linux-gcc is not an > auto-tools Makefile/configure. Thanks! Hamish _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
