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: [email protected] [mailto:[email protected]]on Behalf Of Igor Tandetnik Sent: Tuesday, June 16, 2009 10:57 AM To: [email protected] Subject: Re: [sqlite] Datatypes (D. Richard Hipp) Fred Williams <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

