What! The standard is lacking? Will wonders never cease? Thanks, you saved me from some boring reference reading.
Still think, logically speaking, the construct should throw an error message, rather than make stealth changes to the expected result. Fred -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Igor Tandetnik Sent: Tuesday, June 16, 2009 10:57 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Datatypes (D. Richard Hipp) Fred Williams <f.willi...@verizon.net> wrote: > Is this a violation of SQL Standards? Seems like it should be. As far as I can tell, CREATE TABLE AS SELECT is not part of SQL92 standard at all. If you want to work within the standard, don't use this construct in the first place. Igor Tandetnik _______________________________________________ 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
